unprotect sheet macro

B

belvy123

Hi All

I have a macro that is listed below
It will be used for security keep people from unauthorized use of my excel
file
Anyways. The macro listed below works gret. However I need to add
additional code to have the macro unprotect each sheet before it can clear
the cells as stated in the original macro.
Is anyone able to help with the code needed to unprotect each sheet.

Thanks
 
G

Gord Dibben

See one reply to your other posting in this same group


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unprotect sheet macro 2
Unprotect sheet to "Refresh All" Access queries 2
Protect and Unprotect all worksheets with macro 2
Protection on Worksheets 5
Modifying a protect unprotect macro 10
Qualifying permissions in protect unprotect macro. 3
Spell Check Unlocked Cells Only 9
Protect/Unprotect Multiple Sheets With Full Options 4

Top