Menu manipulation
 

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

Menu manipulation
 

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

Menu manipulation
 

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

Menu manipulation
 

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

Menu manipulation
 

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

Menu manipulation
 

Hi Michael

You not change the controls on the toolbar with code you only set Enabled to false of the Standard toolbar.
Your xlb only know that you set Enabled to false when Excel start after a crash, that's why you must run the restore macro again
after a crash.

Or open the workbook again and close it (it restore the toolbars also then)

Your add-ins build there menu's with code, so you not have a problem with them

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


"Michael Beckinsale" wrote in message ...
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