Steve,
There's no way to do waht you want without opening the workbook on that day.
If we assum you open the workbook everyday, the ideal way to achieve ehat you
want is to create ans 'Auto_exec' macro that performs a check on the date,
and then either exits doing nothing, or runs your update macro, depending on
the result of the date check.
Depending how volatile your source data is you may need to add some
validation and safety checks to ensure the macro is run only once per month,
but that should be fairly ewasy for anyone with some basic VBA knowledge.
HTH
Neil
www.nwarwick.co.uk
"Steve" wrote:
Hi
Is there a way to run a macro - "Update_Me" - on a fixed date, say the
first of every month?
Thanks in advance
Steve