So i have Code in a few different modules and inorder for the code to run properly i need to unlock Sheet3 of my workbook, and then lock it again after the code has run. The Password is stored in sheet3.Range("L2"). But when one module runs it works and when another runs I get:
Run Time Error '1004' "The Password you supplied is not correct. Verrify that the CAPSLOCK key is off and besure to use the correct capitialization."
on open my code calls
Run Time Error '1004' "The Password you supplied is not correct. Verrify that the CAPSLOCK key is off and besure to use the correct capitialization."
on open my code calls