unprotect sheet macro

  • Thread starter Thread starter belvy123
  • Start date Start date
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
 

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
Qualifying permissions in protect unprotect macro. 3
Unprotect sheet to "Refresh All" Access queries 2
Modifying a protect unprotect macro 10
Protect/Unprotect Multiple Sheets With Full Options 4
Protect and Unprotect all worksheets with macro 2
Protection on Worksheets 5
Macros for Protect/Unprotect all sheets in a workbook 2

Back
Top