Customize Standard Toolbar

[eggpap]

I have a wb with standard and custom menus. The custom menu gets loade
on the wb open event from a menu table written on a sheet and deleted o
the wb close event. It makes available some commands related to macros

I need to know if it's possible to use the same table to delete som
standard menus and to reload them on the wb close event.

Here attached the test.xls wb.

Thanks,
Emilian

+-------------------------------------------------------------------
|Filename: test.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=65
+-------------------------------------------------------------------

 

[Bob Phillips]

I suppose you could amend the code to process another menu type, but it
would seem simpler to just hide those you don't want in the Workbook_Open
event, and re-instate them in the BeforeClose event.

 

[eggpap]

I suppose you could amend the code to process another menu type, but it
would seem simpler to just hide those you don't want in th
Workbook_Open
event, and re-instate them in the BeforeClose event.

Thanks,

do you mean a list of statements like this?

Application.ControlBars("Files").Controls("&New...").visible=false/tru
?

Emilian

 

[Bob Phillips]

Yes, like that, but I thought you wanted the whole commandbar, so you can do
it at that level.

 

[eggpap]

No, I need to keep some controls of certain CommandBars.

Thanks, Emilian