Always open a certain worksheet if date is past?

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

wx4usa

Is there a macro or something that will open a specific sheet if a
date is past due? For example, if the date in cell C1 on sheet 1 is
older than today, can the excel workbook always open to sheet 7 from
that point forward?
 
Private Sub Workbook_Open()
If Sheets("Sheet1").Range("C1").Value < Date Then
Sheets("Sheet7").Activate
End If
End Sub

Place into Thisworkbook module.


Gord Dibben MS Excel MVP
 
Back
Top