I have a wb with standard and custom menus. The custom menu gets loaded
on the wb open event from a menu table written on a sheet and deleted on
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 some
standard menus and to reload them on the wb close event.

Here attached the test.xls wb.

Thanks,
Emiliano


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

--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51674

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.

--
__________________________________
HTH

Bob

"eggpap" wrote in message
...

I have a wb with standard and custom menus. The custom menu gets loaded
on the wb open event from a menu table written on a sheet and deleted on
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 some
standard menus and to reload them on the wb close event.

Here attached the test.xls wb.

Thanks,
Emiliano


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

--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51674

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.


Thanks,

do you mean a list of statements like this?

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

Emiliano


--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51674

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

--
__________________________________
HTH

Bob

"eggpap" wrote in message
...

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.


Thanks,

do you mean a list of statements like this?

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

Emiliano


--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51674

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

Thanks, Emiliano


--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51674