Workbook_Open() not running

  • Thread starter Thread starter Udo Fingerhut
  • Start date Start date
U

Udo Fingerhut

This simple macro is in the ThisWorkbook area:
Private Sub Workbook_Open()
MsgBox ("Macro is running")
End Sub
But if I open the workbook, nothing happens.
If I start the macro in the testing window, everything runs fine (th
same result if I copy the macro in a new workbook and open that one).
So my conlusion is, Excel is not realising this macro while opening th
workbook.
I am using Excel 2002 SP2 on Windwos XP. The workbook is an old one
first release using Excel 4.0, after that updated several times
current size of the template about 2 MB.
Has any of you had similar problem with excel events
 
Hi
you have to put this code in your workbook module (named 'ThisWorkbook'
in the vBA editor)
 
Back
Top