Workbook_Open() does not work

G

Guest

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
 
G

Guest

Bob,
I do have application.enable =true. I believe it's a problem with Excel
2003 because it will work with Excel 2000 no problem. Any other ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

workbook_open() sub does not work 2
Private Sub Workbook_Open() 1
Unable to change ActiveSheet within Workbook_Open 2
How to apply a macro to all workbooks 2
Workbook_Open does not work 1
XL97 Private Sub Workbook_Open() Not Working 6
Run a Macro just after i open a workbook EXCEL 1
Workbook_Open Event not firing 3

Top