View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default formula for current date when opening spread sheet

In the thisworkbook module, workbook_open event

sheets("sheet1").range("a1")=date

--
Don Guillett
SalesAid Software

"terryman" wrote in message
...
I have gotten "rusty" sence i retired. i want the current date to show in
my
spread sheet each time I open it. I am using excell 2000.