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