ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   auto_open? (https://www.excelbanter.com/excel-discussion-misc-queries/14480-auto_open.html)

Jack Sons

auto_open?
 
Hi all,

The first time my workbook is opened in any month (could be on another day
than the first day of that month) I want sub ABC() to be executed
automatically. When my workbook is opened again on that day or any other day
of the same month sub ABC() should not be executed.

Sub Auto_Open ()
......................
ABC
......................
End Sub

I can't find a good way to accomplish this. Your help will be appreciated.

Jack Sons
The Netherlands




All times are GMT +1. The time now is 04:19 PM.

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