View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JB2005 JB2005 is offline
external usenet poster
 
Posts: 16
Default 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!