View Single Post
  #3   Report Post  
 
Posts: n/a
Default

Thank you,

this one is usable to, what i mean is, selecting
automaticely a cell with the current date
-----Original Message-----
Private Sub Workbook_Open()
Worksheets(Format(Date, "dmmm")).Activate
End Sub

in the ThisWorkbook code module.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R VAN DEURSEN"

wrote in message
...
I have a worksheet with the dates of a month, say 1jan,
2jan, 3jan etc. Is there a way that excel by opening

the
workbook selects automaticely the current date.



.