Hi,
I have an Excel 2013 sheet with a button that unlocks a sheet and saves that sheet without the formulas and button, (values only), to a new workbook then locks the new sheet but it leaves the original sheet unlocked. I need a way for it to also re-lock the original sheet. I'm just trying to dummy proof this for someone that keeps deleting stuff.
Big thanks to those who have helped me get this far with it.
This is my macro so far:
Thanks,![]()
Please Login or Register to view this content.
Foos Master
"Foosball is Therapy"
Bookmarks