View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R. Todd Miller[_2_] R. Todd Miller[_2_] is offline
external usenet poster
 
Posts: 1
Default 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