Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restricting Menus
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restricting Menus
R
To be honest, I didn't know you could get to the File and Edit menus in that fashion. Here's another way: Application.CommandBars("Worksheet Menu Bar").Controls("Insert").Controls("Rows").Enabled = False -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "R. Todd Miller" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |