View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_613_] Leith Ross[_613_] is offline
external usenet poster
 
Posts: 1
Default CommandBar 'Insert'


Hello Geoff,

When specifying the control name as part of the Controls collection, it
must appear the same as on the menu. This means the shortcut key (the
underlined letter) must also be present. This is entered using the &
character before the letter that will be underlined.

You used in your code...
Application.CommandBars("Insert").Controls("Worksh eet").Enabled = False

Try this version...
Application.CommandBars("Insert").Controls("&Works heet").Enabled =
False

Note: There is no spaces in "worksheet". The post here at ExcelForum
shows them, your post may not.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=557161