macro to unlock worksheet

  • Thread starter Thread starter Kirsty
  • Start date Start date
K

Kirsty

I want my macro to unlock the worksheet before it runs, and then lock it
again after.

At the moment I have Sheets("Daily Report").Select
wsheet.Unprotect Password:="computer"

however this is getting an error.

Any suggestions?
 
Kirsty,

Do it like this

Sheets("Daily Report").Unprotect Password:="computer"
'do things
Sheets("Daily Report").Protect Password:="computer"

Mike
 
thanks, works perfectly

Mike H said:
Kirsty,

Do it like this

Sheets("Daily Report").Unprotect Password:="computer"
'do things
Sheets("Daily Report").Protect Password:="computer"

Mike
Click to expand...
 

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

Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
including macro in protected worksheet 2
Unlocking specific worksheets 3
Macro Code Issue 2
Disable Button When Worksheet is Locked 4
Multiple Worksheets - Protection 3
Protect Worksheet Macro 2
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? 2

Back
Top