Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I can't figure this out so perhaps someone here has some ideas...
The first two lines of code work and grey-out File-New and Edit-Cut. The third line should grey-ouy Insert-Rows but it yields a Runtime error '91': Object variable or With block variable not set. Any ideas (Excel 97). Thanks in advance. Sub RestrictMenus() Application.CommandBars("File").FindControl(Id:=18 ).Enabled = False Application.CommandBars("Edit").FindControl(Id:=21 ).Enabled = False Application.CommandBars("Insert").FindControl(Id:= 296).Enabled = False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sub-menus of main menus for Excel 2007 | New Users to Excel | |||
Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
difference between word 2003 menus and word 2007 menus-Explain pl | Excel Discussion (Misc queries) | |||
New Menus - attaching but menus are reset | Excel Worksheet Functions | |||
Restricting use of menus and toolbars | Excel Programming |