I have a spread sheet with 2 option buttons that the user needs choose from.
The first button places a number 1 in cell E66 and the second one places a 2 in E66.
Is there a way to hide rows depending on which botton is pressed.
I would like to hide rows 28-36 if option one is selected and making sure rows 13-25 are visible. and the reverse if option 2 is selected. Hide 13-25 and make sure 28-36 are visible.
The first button places a number 1 in cell E66 and the second one places a 2 in E66.
Is there a way to hide rows depending on which botton is pressed.
I would like to hide rows 28-36 if option one is selected and making sure rows 13-25 are visible. and the reverse if option 2 is selected. Hide 13-25 and make sure 28-36 are visible.