Unlocking and Locking in a Marco

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!
 
M

Mike

try this
worksheets("Sheet1").unprotect "password"
'run your code here
worksheets("Sheet1").protect "password"
 

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

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
Problem with speed marco excel 2003 and excel 2007. 1
Marco to insert rows 2
Marco that will run if the condition met 2 1
Code doesn't work from in Office 2003 2

Top