Workbook_Open() not running

[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

 

[Frank Kabel]

Hi
you have to put this code in your workbook module (named 'ThisWorkbook'
in the vBA editor)

 

[Ron de Bruin]

Maybe the security is set to High

Tools>Macro>Security