Hello jeeperman4x4,
Welcome to the Forum!
You will need to add a ComboBox control to the worksheet from the Control ToolBox tool bar. Once you have done that, add this code to the control. Set the ListFillRange property to the worksheet and range that will be used for the selections.
Private Sub ComboBox1_Click()
Select Case ComboBox1.ListIndex
Case 0
With Worksheets("Project Status Report")
.Range(.Rows(132), .Rows(185)).Hidden = True
End With
Case 1
With Worksheets("Project Status Report")
.Range(.Rows(102), .Rows(130)).Hidden = True
End With
End Select
End Sub
Bookmarks