Workbook_Open() does not work

K

Ken

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
 
K

Ken

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

Private Sub Workbook_Open() 1
Unable to change ActiveSheet within Workbook_Open 2
workbook_open() sub does not work 2
How to apply a macro to all workbooks 2
Setting column width in a table with a macro is not working 0
Menu Macro Not Executing - Need Help 1
How to set focus on an ActiveX ListBox 7
Auto Calculate selected worksheets 5

Top