have the macro unprotect then protect the sheet again each time it runs
--
paul
remove nospam for email addy!



"Lisa D'K" wrote:

I have a protected worksheet that is located on a shared drive. Everyone
accesses and uses it in a read-only format. I have protected various cells
within the worksheet so that everyone can use tab to navigate only to the
unprotcted cells that require input data. I created a macros to clear all of
these unprotected cells at once so that the spreadsheet can be re-used easily
with less error. I do not want to allow anyone to unprotect the worksheet,
but they cannot run the macro in a protected status. Please help. Thanks.
Excel 2002, Windows XP