Run Macro Upon Opening

  • Thread starter Thread starter Bill Mosserati
  • Start date Start date
B

Bill Mosserati

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically trying to run a macro at a certain time 0
automatically trying to run a macro at a certain time 1
How to Unlock Excel Workbook protected by MACRO Password 6
VBA code to run macro in certain file based on name of file in cel 2
Can I call a macro from a specific book 2
How do I set this up 3
forcing specific sheet opening upon launch of .xlsx file 4
How do I run macros upon opening only if it is not the template? 1

Back
Top