I have several templates that contain a macro which automatically puts the
user name and territory they are assigned into the appropriate cells for
identifying the individual that creates a worksheet when it is opened, then
locks the worksheet. The worksheets are sent into the head office monthly for
review and electronic filing.

Is it possible to protect the user name cell if someone knows the password
to unprotect the overall sheet? Some of the templates were created in Excel
2000 and converted to 2003. We are curreently running 2003. After the
worksheet is created and saved we do not want another person opening the
worksheet to alter the data in the name or territory cells.

Thanks in advance

scruffy