Unlocking and Locking in a Marco
 

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!

Unlocking and Locking in a Marco
 

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

"JBoyer" wrote:

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!

Unlocking and Locking in a Marco
 

That's all I needed. THANKS!

"Mike" wrote:

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

"JBoyer" wrote:

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!

Unlocking and Locking in a Marco
 

Your welcome

"JBoyer" wrote:

That's all I needed. THANKS!

"Mike" wrote:

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

"JBoyer" wrote:

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!