Unlocking and Locking in a Marco

  • Thread starter Thread starter JBoyer
  • Start date Start date
J

JBoyer

I have a marco that will only work if the sheet is unprotected. Can I make my
marco unlock the sheet in the beginning and then lock it when completed. Hope
you can help!
 
try this
worksheets("Sheet1").unprotect "password"
'run your code here
worksheets("Sheet1").protect "password"
 
Back
Top