Hi,
I have an Excel 2013 sheet with a button that saves a sheet to a new workbook. It removes formulas and the button but if I password protect the original sheet it doesn't work. I want to have the original sheet locked so that nobody can accidentally delete any of the formulas. Is there a way to auto-unlock the sheet within that same macro and then re-lock it or is there another way to make it work while protected?
My macro:
Thanks,![]()
Please Login or Register to view this content.
Foos Master
"Foosball is Therapy"
Bookmarks