Workbook_Open() Not executing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Not terribly familiar with debugs. I have been in contact with my help desk.
They can run the macro fine and get the msgbox when workbook is opened
indicating that all the code is executed. Macros security settings are
correct.

we think we have a novell profile problem.

I would appreciate debug tip however
 
AT various points in the code add statement like

Debug.Print "Debug point 1"

then 2, 3 etc.

When the code runs, these will. be shown in the Immediate window in the VBE
(use Ctrl-G in VBE to see this window). By following the debug statements,
you can see which pieces of your code get executed and which do not.
Typically, you would add a few general debug statements, and then when you
identify where it stops, and some more, and drill down into the trouble
spot.

Another way is to use single-stepping. In this, you open up the Workbok_Open
macro, put the cursor in that macro (anywhere in it), and menu Debug>Step
Into (or F8). Then just F8 through the code, and you will step into each
line as it gets executed, and you can trace where it goes wrong.

--

HTH

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