That is what I currently use, but I really need to lock only the TEMPLATE
sheet. I would like to lock the TEMPLATE sheet and sheet name, but allow for
unlimited acces to all other sheets. I need all other sheet names accesible
because I want them to be able to create and modifie sheets of previous days.
The macro names them according to todays date.


Here's my problem:
I created a file for uneducated users that includes a template sheet. I
programmed a macro that copies the template and renames the copy according to
the date. The template keeps disappearing because one of the users renames
the template and then fills it out for that day. He figured out how to
remove the protection, so I placed a password. Now if he renames the
template sheet, he won't be able to copy it (the macro uses the name TEMPLATE
to copy the sheet), and he won't be able to fill the sheet out either.


"Paul B" wrote:

Sloth, you could protect the work BOOK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sloth" wrote in message
...
A user can still change the name of a protected sheet. Is there a way to
disable this via coding, or some other option?