View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary Kathryn
 
Posts: n/a
Default VBA to disable "Delete...." on shortcut menu of worksheet tab?


I have a spreadsheet where I don't want users to be able to delete a
worksheet. How do I code it so that the "Delete..." on the shortcut
menu for the worksheet tabs is disabled? I'm thinking that part of the
code is:

.Controls("Delete...").enabled=False


but can't figure out the rest.

Thanks for any help!


--
Mary Kathryn
------------------------------------------------------------------------
Mary Kathryn's Profile: http://www.excelforum.com/member.php...o&userid=31905
View this thread: http://www.excelforum.com/showthread...hreadid=518725