Hi,
I've got a checkbox which i've linked to a cell.
Then 4 rows will get the TRUE or False result from this tick box.
I've added macro buttons which hide & unhide when TRUE or False, however is there (and if so what is) the formula for setting the macro that i don't need to use the buttons to hide/unhide.
In other words when i untick the box, which changes the cell value to False then the macro will run to hide the rows which have FALSE in them.
I've attached the spreadsheet (with instructions).
Column B determines whether the row should be hidden. Some cells need to remain so i have given them the value TRUE.
Thanks,
Misha
Bookmarks