View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default prevent user from deleting a tab prevent running macro from menu

1. deleting a specific tab in a workbook? PROTECT the workbook.

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)? Maybe you could tweak the macro
to ensure it's being run on the correct worksheet. To prevent it from the
tools menu can be a bit complicated.
--
HTH,

Barb Reinhardt



"joemeshuggah" wrote:

how can one prevent a user from

1. deleting a specific tab in a workbook?

2. prevent a user from running a macro from the tools menu (where user can
only run a macro from a command button)?

thanks!