How to reference locked cell in VBA?

[Sara79]

I want to be able to double click a cell and then insert a row under the clicked cell that copies the formula from the above locked cells.

When the sheet is unprotected, the code works fine. But when I try and the sheet is protected I get the error below. Is there a work around?

 

[Fluff]

You can unprotect the sheet at the start of the code & protect it again at the end.

 

[Sara79]

You can unprotect the sheet at the start of the code & protect it again at the end.

Can you elaborate on what you mean? I am very new to using VBA code and such.

 

[Fluff]

Put this as the 1st line of codeMe.Unprotect "Password" and this as the last line Me.Protect "Password"
Change Password to whatever you password is.

 

[Sara79]

Put this as the 1st line of codeMe.Unprotect "Password" and this as the last line Me.Protect "Password"
Change Password to whatever you password

Would {Me.Unprotect "" } be the same as having no password?

 

[Fluff]

If you don;t have a password just removeing the quotes & everything inside.