View Full Version : excel 2007 prevent custom toolbar showing until


smiler44
07-13-2009, 11:49 AM
My Excel 2003 custom toolbar appears in Excel 2007 as an Add-in when the workbook is opened. If the user does not enable macros and closes the workbook the toolbar stays visible/accessable as an addin.

How can I prevent the toolbar appearing as an Add-in until the user enables macros? I have tried removing the toolbar.visible = true code so no code is making the toolbar visible but still it appears as an add-in when the workbook is opened.
smiler44

smiler44
07-26-2009, 08:24 AM
I think I have sorted this. Part of my problem seems to be a difference between excel 2003 and excel 2007. By changing my code in excel 2007 I seem to have found a resolution. I have replaced toolbar.delete with toolbar.hide when the work book closes, this has also overcome the problem of command buttons being in a different state when the workbook next opens
smiler44