You would want to use an Event macro.
Event Macros, Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm
Worksheet_Activate Event (#ws_activate)
http://www.mvps.org/dmcritchie/excel...tm#ws_activate
which is set up for the current date upon sheet activation
you can limit it to a specific column.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"The Fool on the Hill" wrote in message
...
Dear Excell(ent) users,
I have a file with multiple sheets. In those sheets I work with dates
(dd-mm-yy). What I am looking for is a macro which opens the file in those
sheets at the current date.
For instance 15-03-2007 is in Cell BX3, so when it would be 15-03-2007 when
I open that sheet, the cursor should be in BX3.
Can you help me, please?
Thank you !