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