Unprotecting a Worksheet in Excel Macro

[Mechanic]

I want to run a macro from the active sheet but I want to unprotect a different sheet so I can change a formula in it. I've tried:

Worksheet("sheet2").Unprotect

while the active sheet is "sheet1". This didn't work, I get an error message that says "Sub or Function Not Defined".

What is the correct command?


Mechanic

 

[AJ]

Try

Sheets("Sheet2").Unprotect

instead.

Rgds
AJ