Toggle hide/unhide macro for a range of cells with values, borders and background colors.

[edge37]

Hello! I've been trying to get a code to hide/unhide a range of cells (AF10:AI23) on a worksheet named "10A (1)" to use it with a button. What I need is to hide cell values/formulas, borders, and background cell colors from that range of cells, and also unhide it back with everything in the exact same way, with original borders and colors. I sent a pic with the table in mention.

Is it possible?

Thank you again for your help!

 

[Alex Blakenburg]

I was going to suggest hiding the columns rather than the rows, but the OP has come that conclusion himself and I think this thread is superceded by:

Toggle hide/unhide columns without affecting tables or text boxes on top

Hi! I'm trying this code to toggle hide/unhide columns in my worksheet: Sub ToggleColumnsAFtoAIWithoutAffectingObjects() Dim ws As Worksheet Dim targetColumns As Range Dim obj As Shape ' Set the worksheet Set ws = ThisWorkbook.Sheets("10A (1)") ' Set the target...

www.mrexcel.com