formula for current date when opening spread sheet

T

terryman

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.
 
D

Don Guillett

In the thisworkbook module, workbook_open event

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

Gord Dibben

In a cell enter =TODAY() and format to the style of date you like.

If you also want the time use =NOW() instead.


Gord Dibben MS Excel MVP
 
Top