excel 2007 prevent custom toolbar showing until

smiler44

Registered User.
Local time
Today, 17:15
Joined
Jul 15, 2008
Messages
671
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
 
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
 

Users who are viewing this thread

Back
Top Bottom