View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Workbook_Open() Not executing

Dave,

Why don't you put some debug statements in the code and find out where it
stops working?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dave is Miffed" <Dave is wrote in message
...
Miffed.

My spreadsheet which relies hevily on certain code being executed when the
sheet is opened, but work open event is not executing. This morning it
stopped working?

Private Sub Workbook_Open()

Application.ScreenUpdating = False
MsgBox "Made it to wrokbook _open"
Call InitialiseSheet
Call Add_Custom_Menu
Call Run_Filters

Application.ScreenUpdating = True
Range("a2").Select
End Sub

There is no enable event code either false or true in the workbook.

Any ideas?

Dave