Only hide rows on open

[flavioso]

Hello. In my sheet activate code, I have a series of rows hidden, as shown below.

Private Sub Worksheet_Activate()
Range("16:364").Select
Selection.EntireRow.Hidden = True
'Hides everything when the sheet opens
End Sub

I have check box controls that if a user clicks in a specific check box, it unhides a certain set of rows. I would like to know if there is anyway that should I go to another sheet, and come back to the master sheet, that it doesn't go back and re-hide the whole range again. Basically, I only want all rows hidden when the worksheet is opened the first time, but any additional focus set to the master page, doesn't "re-activate". Is there anyway to do this?

Or, better yet, it leaves it as it was before I switched to another sheet, (i.e. meaning the current rows hidden/current rows shown)

I appreciate any advice.

Brad

 

[doofusboy]

You could record in a hidden cell whether the worksheet has previosuly been activated and check that cell in your worksheet activate code. Something like this:

Private Sub Worksheet_Activate()
    If Range("AA1").Value = "Yes" Then          ' you can hide columnAA so no one sees this
        ' worksheet has already been activated
        Exit Sub
    Else
        ' worksheet has never been activated before so record first activation
        Range("AA1").Value = "Yes"
        'Hides everything when the sheet opens
        Range("16:364").EntireRow.Hidden = True
    End If
        
End Sub

 

[Glory]

When you talk like, saying, it's really hard to, this, understand what you're.

Public Toggle

Private Static Sub Worksheet_Active()

If Toggle = False
Rows.Hide
Toggle = True
Else
End If

End Sub

Probably something along those lines.