Hi,
I have a protected worksheet, I have the below code which unprotects, updates, and then reprotects. I have been able to add a CommandButton within this sheet which runs the macro, however my problem is whenever I put a CommandButton in another worksheet I receive error 1004. It doesn't seem to be able to reference the sheet I am trying to update.
Any assistance in resolving this would be greatly appreciated. I would also like to make the password private - therefore prompting the user to enter the password.
Thank you
Bookmarks