I am trying to hide several rows whenever the option button "no" is checked in a groupbox in a spreadsheet. I could not get any code to run when the option buttons were checked, so I set the cell link to R27 and then put into R26 the formula =R27. This seems to work with the code below, but the spreadsheet is constantly updating, with lots of spinning cursors and eventual freezing. Is there a simple fix, or a more direct method than my workaround?
[VBA]Private Sub Worksheet_Calculate()
Dim target As Range
Set target = Range("R26")
If target.Value = "2" Then
Rows("35:68").EntireRow.Hidden = True