Custom toolbars and shared drive

[Andrew]

I created an Excel workbook that has customized menus and
toolbars. When I save the workbook to a shared drive,
others were unable to access the customized toolbars and
menus. So, I redefined the toolbars and menus
from "custom toolbars" to "toolbars in the workbook" and
saved this to the shared drive. Others were then able to
use the menus on the spreadsheet but the toolbar format
definitions stayed attached to their personal Excel
configuration.

My question is this, how can I quarantine the
configuration to a specific file on the shared drive
without re-defining the users Excel definitions?

 

[Guest]

sub auto_close()
Application.CommandBars("Andrew's Toolbar").Visible = False
End Sub

 

[Guest]

If I understand correctly, you essentially want that toolbar to close when these other users close the spreadsheet.

I'm not a macro expert, but something like this might work.

sub auto_close()

Application.CommandBars("Andrew's Toolbar").Visible = False

End sub

The caveat is that the have to enable macros when they open the file, or similarly arrange their security options.

 

[Guest]

sub auto_close()

Application.CommandBars("Andrew's Toolbar").Visible = False

end sub

 

[Guest]

I kept getting an error saying my reply wasn't sent. sorry for the redundancy.