Password from cell

K

Kashyap

Hi, I was trying to lock and unlock sheet using macro and the password should
pick from a cell (P1) from the same sheet

can anyone help me with this?

Thanks..
 
J

Jacob Skaria

ActiveWorkbook.Sheets("Sheet3").unprotect Range("P1")

If this post helps click Yes
 
J

Jacob Skaria

strPassword = ActiveWorkbook.Sheets("Sheet3").Range("P1")
ActiveWorkbook.Sheets("Sheet3").Unprotect strPassword

If this post helps click Yes
 

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

Returned position address on protected sheet 7
Modifying a locked/protected sheet 3
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? 2
Macro Help - 2 sets of sheet array 1
Progressive number in different sheets 7
Clearing formulas 1
Error locking cell 4
"Lock project for viewing" doesn't get saved 1

Top