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!
|