solution 2 works great...thanks!

solution 1 though i am still not sure on. i have a macro in the workbook
that adds sheets. i added made the structure protection false before the
macro adds the sheets, and then true after the sheets are added. however,
the user needs to have the ability to delete or rename the sheets that were
added in the macro. is there a way around this?

"Dave Peterson" wrote:

#1.

Protect the workbook's structure.

In xl2003 menus:
tools|protection|protect workbook|check structure

#2.

Make the sub private:

Sub Testme()
becomes
Private Sub testme()

This will stop the user from seeing that subroutine--but if they know the name,
they can still type it and run it.




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!

--

Dave Peterson
.