Weird problem

I have just added auto_open and auto_close procedure to my workbook which worked fine. Since reopening though when I select a sheet that I have a text box on it seems to do some sort of calculation or macro or something. It is not doing the auto_open or close procedures because I am not getting the messageboxes. It just seems to 'flash' several times, different amounts for different sheets. The worst case it continued for about 2 minutes before stopping. I am using excel 2003 and it is a fairly involved workbook. It is like a macro performing a loop but there shouldn't be one running. It does not do it on sheets that do not have a text box on it.
Any ideas?

anything on the Worksheet_Change trigger?

Umm... excuse my ignorance, but what is the worksheet_change trigger?

worksheet_change trigger are macros that are trigged by an event occuring in the worksheet (similar to the open & close macros) and are placed in the worksheet & Thisworkbook modules

What macros do you have listed that their names start with

Private Sub Worksheet_???????

or

Private Sub Workbook_?????

I don't believe there is any of those in the workbook.

It sounds like our Aussie friend is using the older method of naming a macro Auto_Open.

Nothing wrong with that. But, you should also learn about Event-driven procedures.

Here is a good overview of the subject:

http://www.cpearson.com/excel/events.htm

Yes on that you are probably right since I have an old visual basic user guide that was out with Excel 5. So I have just named the sub Auto_open and Auto_close which is what it said to do. I currently have made those just rem each line as I am not sure I need to use it. Instead I may just open the data sheet when required which is the reason I have asked one of my other questions regarding checking if a sheet is open.