Thread
:
Workbook_Open() Not executing
View Single Post
#
2
Posted to microsoft.public.excel.programming
Bob Phillips[_6_]
external usenet poster
Posts: 11,272
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
Reply With Quote
Bob Phillips[_6_]
View Public Profile
Find all posts by Bob Phillips[_6_]