Unprotect/Deleting All/Copy

[staceyblewin]

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?

[6StringJazzer]

I did not do the part for removing checkboxes because I don't know what kind of checkboxes you have. Are they Form Controls or ActiveX?

Please Login or Register  to view this content.

Have you tried your hand at writing this yourself?