Hi Ron,

Sorry for all the questions but l might be missing something here. If l run
the 'restore' macro does it refer to the Excel8.xlb file to find what the
personalised menu items were? If not how does Excel know what my
personalisations are ? ie for example l have added the row & column insert /
delete icons to the 'Stanadard' toolbar?

Regards

Michael
"Ron de Bruin" wrote in message
...
Hi Michael

No if Excel crash you must run the 'Restore' macro to get your menu's
back

Note: Use the activate and deactivate event of the workbook to run the
code


As you can probably gather l am quite nervous about loosing my
personalised menu
Make a backup



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


"Michael Beckinsale" wrote in message
...
Ron,

I take it that the 'Restore' (ie controls = enabled) works for all the
personalised menus because Excel has not been closed and it is therefore
'remembering' which controls have been disabled?

Does this mean that if Excel crashes or Excel is closed without saving /
closing the workbook which disables the menu the original menu settings
would be lost or would the excel8.xlb restore them?

As you can probably gather l am quite nervous about loosing my
personalised menu

TIA for your help on this one

"Ron de Bruin" wrote in message
...
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