MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need to automatically change the date when I open a workbook

Posted by Nik Holden on July 03, 2001 1:48 AM

I have a spreed sheet that needs to have the date automatically changed to the current system date when I open the workbook up. I already have the macro set up to change to the system date and current day but I am stumped at how you get a macro to automatically run when you open a workbook. Please help.


Posted by Paul R on July 03, 2001 4:43 AM


Is your date in a cell? If so could you use
=NOW() in the cell rather than a macro.