Unprotect > Run Loop > Protect

I have a macro that runs a loop on most sheets to clear colored cells. All worksheets are protected and I can't seem to integrate my protect and unprotect macros (which work!) into the clearing macro. Here are all 3:


Clear cells

Please Login or Register  to view this content.

Unprotect all sheets

Please Login or Register  to view this content.

Protect all sheets

Please Login or Register  to view this content.

How can I integrate the 1. unprotect all sheets, 2. run clear macro, and 3. protect all sheets?

Thanks! That works!

Hi again, Ron. Thanks for your help... I'm experiencing an odd reaction to your solution. Sometimes, seemingly only when the workbook is opened (and was previously protected).


Your solution works when I protect the sheets and then try to run the clear while its protected. But NOT when the sheet was protected, then closed, then opened, and then clear attempted to run...

Hope that makes sense...

This does not work as a solution... Can someone help me integrate the unprotect, code, then protect macros?