Posted to microsoft.public.excel.programming
|
|
Disable commands for one workbook
Thank you both!
--
Steve C
"Tom Ogilvy" wrote:
These are application level settings. Therefore you would need to set them
each time a workbook became active. Instantiate application level events in
this workbook and use the WorkbookActivate and WorkbookDeactivate events to
control the settings
http://www.cpearson.com/excel/appevent.htm
--
Regards,
Tom Ogilvy
"Steve C" wrote:
I am using the following commands to disable certain options for a specific
workbook. However, if any other workbooks are open, these same options are
also disable for them. How can I disable commands only for a specific
workbook rather than all open workbooks? Thanks.
Application.CommandBars.Item("Data").Controls.Item ("Filter").Controls.Item("&Advanced Filter...").Enabled = False
Application.CommandBars.Item("Tools").Controls.Ite m("&Customize...").Enabled
= False
Application.CommandBars("Toolbar List").Enabled = False
--
Steve C
|