- Registration date
- Saturday May 23, 2009
- Last seen
- October 20, 2010
hit f1 in excel
type these words into the search box
auto_open macro event excel
go down the list until you get to run a macro.
in there it mentions that if you try your nightly macro in vba instead it over rides auto_open macros, so those other 3 would not run.
have a read see if it helps.
sorry, you did not mention which office version you are using. the above is for 2007, but i'm sure there would be a similar solution in previous versions.