Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menus in Excel 2007
Not sure if this is the correct group but...
This proc in E 2003 no longer does what is required in E 2007 and only gets by because of 'On Error Resume Next': Sub DisableMenus() '''Disable 'Sheet' menus On Error Resume Next '''Insert Worksheet Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=852, Recursive:=True).Enabled = False With Application.CommandBars("Edit") .Controls("Delete Sheet").Enabled = False .Controls("Move or Copy Sheet...").Enabled = False End With Application.CommandBars("Ply").Enabled = False On Error GoTo 0 End Sub Does anyone have an idea how to convert? Geoff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub-menus of main menus for Excel 2007 | New Users to Excel | |||
Excel 2007 vs 2003 menus. | Excel Worksheet Functions | |||
Excel 2007 menus - how can I get rid of them? | New Users to Excel | |||
EXCEL 2007 Menus | Excel Discussion (Misc queries) | |||
Customizing Menus in Excel 2007 | Excel Discussion (Misc queries) |