On Close or On Open

[RandyD123]

Looking for a VBA to hide two tabs on close or on open of my workbook. Tabs that should be hidden are "Sheet1" and Sheet2". Thank you for any help.

 

[KOKOSEK]

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("Sheet1").Visible = 2
Sheets("Sheet2").Visible = 2
End Sub

Private Sub Workbook_Open()
Sheets("Sheet1").Visible = 2
Sheets("Sheet2").Visible = 2
End Sub

 

[RandyD123]

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("Sheet1").Visible = 2
Sheets("Sheet2").Visible = 2
End Sub

Private Sub Workbook_Open()
Sheets("Sheet1").Visible = 2
Sheets("Sheet2").Visible = 2
End Sub

Thank you, works perfectly!!! One quick question, do I need both because I notice "on close" it's done, so I don't see how "on open" would matter?

 

[KOKOSEK]

I know that you've written on close OR on open. I give you both.
It is up to you.

 

[RandyD123]

Thank you!!!