Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
In xl2003 I cannot disable the 'Insert' commandbar or any of it submenus. This code works for other commandbars for example Application.CommandBars("Format").Enabled = False or Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=178, Recursive:=True).Enabled = False or With CommandBars("Edit") .Controls("Delete Sheet").Enabled = False .Controls("Move or Copy Sheet...").Enabled = False End With So why not this? It runs without error but doesn't do the job. Application.CommandBars("Insert").Controls("Worksh eet").Enabled = False Grasping at straws are there reasons why commandbars cannot be disabled for example I use Rows("1:1").Insert Shift:=xlDown later in the code. Appreciate any advice on this. T.I.A. Geoff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cant dim as commandbar | Excel Programming | |||
Create CommandBar | Excel Programming | |||
CommandBar | Excel Programming | |||
Commandbar frustration. | Excel Programming | |||
commandbar | Excel Programming |