command disabling
 

Any ideas on how to de-activate(dim) and then re-activate specific commands
from any menu or toolbar they are placed in?

For example, I want to disable the OPTIONS command during the period a
workbook is open and it shouldn't be active from ANY menu or toolbar.

Already the script records original settings, applies the required settings
and on closing, restores the original settings.

However, the workbook is vulnerable to OPTION changes during the period it
is open!

command disabling
 

Hi JB2005

Start here
http://www.rondebruin.com/menuid.htm

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


"JB2005" wrote in message ...
Any ideas on how to de-activate(dim) and then re-activate specific commands
from any menu or toolbar they are placed in?

For example, I want to disable the OPTIONS command during the period a
workbook is open and it shouldn't be active from ANY menu or toolbar.

Already the script records original settings, applies the required settings
and on closing, restores the original settings.

However, the workbook is vulnerable to OPTION changes during the period it
is open!

command disabling
 

EXCELLENT!
:)

"JB2005" wrote:

Any ideas on how to de-activate(dim) and then re-activate specific commands
from any menu or toolbar they are placed in?

For example, I want to disable the OPTIONS command during the period a
workbook is open and it shouldn't be active from ANY menu or toolbar.

Already the script records original settings, applies the required settings
and on closing, restores the original settings.

However, the workbook is vulnerable to OPTION changes during the period it
is open!