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