I want to be able to show more or less of the screen by clicking a radio
button.

I have a VB script as below (par of it shown only)

I have 13 x =EMBED("Forms.OptionButton.1","") numbered 1 - 13 They
are called OptionButton_1 - 13

By clicking on the corresponding radio button - I want it to show as much
of the worksheet that is necessary. hiding the parts that are not wanted

The worksheet contains almost exactly the same going downward 13 times for
producing a site survey, for different size sites

I have worked out the rows that will need to be displayed.

I have seen it working before but can't work out how it was done.

** Happy to email file if it helps**

If Me.OptionButton_5.Value = -1 Then
Rows("36:175").Hidden = False
Rows("176:452").Hidden = True
End If

End Sub

Private Sub OptionButton_6_Click()

If Me.OptionButton_6.Value = -1 Then
Rows("36:210").Hidden = False
Rows("211:452").Hidden = True
End If

End Sub

Private Sub OptionButton_7_Click()

If Me.OptionButton_7.Value = -1 Then
Rows("36:245").Hidden = False
Rows("246:452").Hidden = True
End If

End Sub