Hiya

I have a spreadsheet which is used a lot and often left
open over night. Several cells include =Today() to
generate various dates.
The problem is that unless the sheet is closed and re-
opened each day, the day doesn't change.

Is there any way I can get the sheet to re-calculate every
time the workbook is activated.
I've tried the following but without success.
Sub Workbook_Activate
sheet1.calculate
end sub

thanks