Thread: Workbook_Open
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Workbook_Open

Hi Jim,

One possibility is that EnableEvents has been set to false, perhaps by
interrrupted code operation.

In case this is the reason, run:

Sub Test()
Application.EnableEvents = True
End Sub

---
Regards,
Norman



"Jim Zeeb" wrote in message
...
The code in ThisWorkbook.Workbook_Open is not getting executed when the
workbook is opened. I put a Msgbox right at the top of the code and I
never
see it.

InTHANKSAdvance