Hi Michael

I have information on this page
See the links on the bottom to create your own menu's
http://www.rondebruin.com/menuid.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Michael Beckinsale" wrote in message ...
Hi All,

I would like to do the following upon opening / closing a specific workbook using the relevant workbook events.

On Opening:
1. Hide my current excel menubars (which have beens modified to my personal preference and have several add-ins present) but
leave File, Open, Close, Save As visible.
2. Add a customised menu say 'MyMenu'

On Closing:
1. Restore the original menu settings (including personal preferences, add-ins etc)

It is very important to me that the restore does not just "reset" the menu to the standard Excel menu.

Does anybody have the code to do this please ?

TIA

Michael Beckinsale