View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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!