Can someone tell me how to unhide rows when a checkbox is checked and then hide the same rows when it is unchecked? I'm new to Excel programming, so feel free to give lots of detail if you like. Thanks!!
Please excuse the thread revival, but my google search brought me to this thread.
Just to say thanks to lenze and NateO, a simply given answer that's enabled me to input VBA code (first for me) and it works !! It's for a word document I'm re-designing into Excel (why do people write tables in word ???).
If I put in this Macro, but then need to add some rows above those covered by the checkbox functionality, the Macro won't update automatically will it?
e.g. rows 10-20 are covered by the checkbox tick. If I then need to add a new row at line 6, the macro code still refers to rows 10-20 whereas I would like it to automatically realise that now the checkbox tick is covering rows 11-21.