Excel (2K) Menu help

[AlanN]

Is it possible to configure a spreadsheet so that when one opens it, a menu item can appear within the regular menu items (File, Edit, View,etc.)?
If the spreadsheet is closed, I would then expect the menu option would disappear.


TIA, AlanN

 

[Bob Phillips]

Hi Alan,

Something like

Application.Commandbars("Worksheet Menu Bar").Enabled= False
Application.Commandbars("Formatting").Visible = False
Application.Commandbars("Standard").Visible = False
etc.

in the workbook close event, and the opposite values in the workbook open event.

But why, don't you need these menus in other workbooks?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Is it possible to configure a spreadsheet so that when one opens it, a menu item can appear within the regular menu items (File, Edit, View,etc.)?
If the spreadsheet is closed, I would then expect the menu option would disappear.


TIA, AlanN