-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Run a macro only if its the first time opening a model?
- Thread starter squnibi
- Start date
Thats a good point. Maybe I should have explained better. So the macro should run every time the model is opened. So if you open the model at 10 am, the macro should run. If you close out of the model and re-open at noon, it should run the macro again. So it should run every time the model is opened.
Upvote
0
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
pcc
Well-known Member
- Joined
- Jan 21, 2003
- Messages
- 1,382
- Office Version
- 2021
- Platform
- Windows
original post said
How would I be able to set up a code that will run a macro only if it is the first time you open the model that day?
Make up your mind..!
If you want it run every time it's opened just stick it in the workbook_open routine.
Upvote
0
