Hide and Unhide

[abee4life]

Im using this code to go from one sheet to another, which is hidden. Is there a way that, after i saved my work and closed down, the next day the page will be hidden again?

Sub Macro5()
'
' Macro5 Macro
' Macro recorded 04/04/2006 by ***
'

'
    Sheets("Group Code").Visible = True
    Range("A1").Select

    Sheets("Group Code").Select
End Sub

 

[Andrew Poulsom]

Put this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Sheets("Group Code").Visible = False
End Sub

in the workbook's ThisWorkbook module.

 

[abee4life]

cheers