I'm using Excel 2003 with SP2. The Workbook_Open() does not work. For
example, the following macro will work if you run it manually in the VB
editor, but will not run when the workbook opens. None of my Workbook_Open()
macros work. The macro is placed in the ThisWorkbook object. Can anyone
help me?

Private Sub Workbook_Open()
MsgBox Date
Worksheets("Sheet1").Range("A1").Value = Date
End Sub