Thread
:
How do I set this up
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
How do I set this up
OK. In the thisworkbook module put in a workbook_open macro to run the macro
and put todays date somewhere. Have the macro check to see if the date is
later or not run.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ayo" wrote in message
...
I want to setup a macro, in a file, that only run once on a specific day
of
the week regardless of who first open the file. The macro needs to run
only
once, every monday, the first time the file is open. Any subsequent
opening
of the file after that, the macro should not run.
How do I go about setting this up? I just need someone to point me in a
generally direction and I should be able to take it from there.
Thanks
Ayo
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett