Hi, I was wondering if there is a way to toggle clear/hide everything from a worksheet except from a range of cells I could specify and also bring everything back using VBA. The idea is that I want to print a, empty table and later on, print the values over that same paper once I'm ready to do so, then restore the original format once again (using a macro button to toggle it on/off). The range of cells I want to keep their values is C9:S33, everything else: format, conditional formating, objects, text, borders would be cleared/hid, and, with the same button with macro bring back everything once I need it back again.
Hope I could explain myself.
Thank you very much
Screenshot_21.jpg
Bookmarks