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"
 
That's all I needed. THANKS!

Mike said:
try this
worksheets("Sheet1").unprotect "password"
'run your code here
worksheets("Sheet1").protect "password"
Click to expand...
 
You must log in or register to reply here.

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
Marco that will run if the condition met 3
Opposite of a marco 7
USE EXCEL MARCO LIKE OLD VERSION LOTUS-123 ---> {?} 3
Open File Marco 3
excel macro help 10
Returned position address on protected sheet 7
Problem with speed marco excel 2003 and excel 2007. 1

Back
Top