Beginner's problems with Workbook_Open
Posted by Richie on June 30, 2001 12:56 AM
I've just written my first spreadsheet that makes use of macros (I told you it was a beginner's problem!).
One of the macros is set-up to display a message box when the workbook is first opened. The macro works fine when the workbook is opened. However, my problem is that once that workbook is closed, if I open another workbook the macro is executed again! The only way around this is to close Excel and start again. The macro is stored in the 'ThisWorkbook' section and I selected 'Workbook' from the drop-down menu in the VBE (which then automatically provided the basis for the Workbook_Open sub.
I've looked in the help section and the previous posts on this board but can't find the answer. Any ideas?
Thanks in advance. Richie.