View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wes_A[_2_] Wes_A[_2_] is offline
external usenet poster
 
Posts: 37
Default Date dependent macro - run once only

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?