Display Todays date on opening file

Try this macro - it selects the cell with todays date in it when the workbook is opened


'These instructions pre typed & are worded to cater for the novice programmer

'To install macro to correct location

'Copy this macro
'GoTo Excel
'Open VB Editor by pressing Alt + F11
'Just below the menus & toolbars on the left you should see Project - VbaProject window
'In this window you will see ThisWorkbook
'double click on ThisWorkbook - opens ThisWorkbook module sheet
'Paste macro code into big window on right

Private Sub Workbook_Open()
   Dim rFound As Range
   
   Set rFound = Columns("b:b").Find(What:=Date, LookIn:=xlFormulas, _
        LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False)
   If Not rFound Is Nothing Then
      rFound.Activate
   End If
   Set rFound = Nothing
End Sub