Unprotecting 4 sheets before "WorkbookOpen" macro runs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to run a workbookopen macro but i keep getting an error staing
that i am trying to edit a protected worksheet or cell. I do have all of the
worksheets in this workbook protected but i am trying to run a macro to clear
certain cells at open . Can someone tell me how to write it so that it
unprotects all of the worksheets before it tries to clear the cells?
 
Hi kcdonaldson,
Record a macro that unprotects the worksheet, select a cell so that
you will have a distinct separation between the two parts, then
protect the worksheet. During the recording if a password was used
it will be recorded. You will then have the code that you can incorporate
before and after coding that you are doing to each sheet.--
 

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

Protect and Unprotect all worksheets with macro 2
Qualifying permissions in protect unprotect macro. 3
Modifying a protect unprotect macro 10
Protection on Worksheets 5
Unprotect sheet to "Refresh All" Access queries 2
Unprotecting worksheets 2
unprotect sheet macro 1
Creating Macro to Unprotect and unhide 2

Back
Top