Hello all
I have a massive spreadsheet with checkboxes, formulas, protection and hidden columns. I use it for monthly tracking, but once the month is over, I just need the data and not all the bells and whistles.
I need a macro that will Unprotect every sheet, copy and paste every sheet as value, Delete all checkboxes on every sheet, Unhide all columns on every sheet, delete columns E-Q (on all but one page) and then protect the workbook.
Sounds like I need a lot. Is this too much for a Macro to complete?
Bookmarks