ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run Macro Upon Opening (https://www.excelbanter.com/excel-programming/301837-run-macro-upon-opening.html)

Bill Mosserati[_2_]

Run Macro Upon Opening
 
Hey Gurus of programming,

Is there any way to set an event or macro to run when a
workbook is first opened every monday? I am sure you can
program something to run when you open it, but can you
specify a particular day of the week?

Thanks all!

Tom Ogilvy

Run Macro Upon Opening
 
have it run everytime you open it, and in the very top of the macro check
what day of the week it is. If it isn't the correct day, then have it Exit
Sub

--
Regards,
Tom Ogilvy

"Bill Mosserati" wrote in message
...
Hey Gurus of programming,

Is there any way to set an event or macro to run when a
workbook is first opened every monday? I am sure you can
program something to run when you open it, but can you
specify a particular day of the week?

Thanks all!





All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com