| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
| How can the right-click shortcut menu in Excel be edited? | Excel Discussion (Misc queries) | |||
| is there a shortcut to move from one worksheet to another, in Exc. | Excel Discussion (Misc queries) | |||
| Disable menu selection | Excel Discussion (Misc queries) | |||
| shortcut menu | Excel Discussion (Misc queries) | |||
Threaded Mode
