Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What I would do is;
1. Setup a last run month cell. It contains the month number of the last time the RunOnce macro ran. 2. At the beginning of the Workbook_Open macro, check the value in your last run month cell. If the value is different from this month's number, then trigger your RunOnce macro. 3. At the end of your RunOnce macro, update your last run month cell. "Wes_A" wrote in message ... XP Pro / Excel 2007 I need to run a macro once only each month when the workbook is opened for the first time in the new month. i.e. It should not run again in the same month. However, it should not skip a month in the (unlikely) event that the workbook is not opened at all during that month and is only opened in the month following...... Can anyone assist with code for this one? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date-dependent calculation | Excel Worksheet Functions | |||
Results dependent on date | Excel Discussion (Misc queries) | |||
Dependent Macro/Toggle Buttons | Excel Programming | |||
macro to run a separate macro dependent on value in cell | Excel Programming | |||
how to make macro not dependent on datafile which has date as its part. | Excel Programming |