Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Add/Delete/Move Worksheets
Hi
I'm looking for an easy way of being able to prevent a user from being able to manually add/delete or move worksheets in an excel workbook. I'm thinking that the best way of doing this is to use the workbook_activate and workbook_deactivate event procedures to initiate code where these options are removed from the 'Edit' and 'Insert' dropdown menus in the main menu and also the menu that appears when you right-click a worksheet's name. However, do I have to complete remove the items from the menus?, or can I simply write some code to make them 'disabled' (e.g faded writting). Do I have to refer spefically to the menus mentioned above or can I write code that disables the add/delete and move options. Any help appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Add/Delete/Move Worksheets
Protect your workbook jamiee
ToolsProtectionProtect workbook -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "jamiee" wrote in message om... Hi I'm looking for an easy way of being able to prevent a user from being able to manually add/delete or move worksheets in an excel workbook. I'm thinking that the best way of doing this is to use the workbook_activate and workbook_deactivate event procedures to initiate code where these options are removed from the 'Edit' and 'Insert' dropdown menus in the main menu and also the menu that appears when you right-click a worksheet's name. However, do I have to complete remove the items from the menus?, or can I simply write some code to make them 'disabled' (e.g faded writting). Do I have to refer spefically to the menus mentioned above or can I write code that disables the add/delete and move options. Any help appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I disable the delete command for a file | Excel Discussion (Misc queries) | |||
How do I disable or delete an Add-In | Excel Discussion (Misc queries) | |||
Disable the Delete Key | Excel Discussion (Misc queries) | |||
Disable Delete | Excel Discussion (Misc queries) | |||
Confirm Delete Message Disable | New Users to Excel |