Hiding and Un-hiding Cells in a sheet based on Values in Another

[aheisler]

I am attempting to hide and un-hide a row in a sheet ("Concrete") based off of the value yielded from a option button in a different sheet ("Bid Analysis", where the VBA is written) but I can't seem to do so just by changing the option button. I actually have to open Visual Basic and run the code in order for the row to hide un-hide, and I want this to occur automatically if the option button is switched. This is a "Form Control" Option button, so the code is in the sheet and not the button itself.

Here is the code that I have come up with:

Please Login or Register  to view this content.

[TMS]

I think you would either need to check for the option button value (True/False) or use a Worksheet Change Event handler to monitor the cell G2 for changes.