Is it possible to debug an Auto_open Module? How?

  • Thread starter Thread starter david.f.jenkins
  • Start date Start date
D

david.f.jenkins

I just don't seem to be able to get into the debugger to figure out
what's going on in an Auto_open module. I guess it's because of the
sequence of events that takes place when I bring up PowerPoint. Is
there any way clever way to do it?

Thanks.
 
I just don't seem to be able to get into the debugger to figure out
what's going on in an Auto_open module. I guess it's because of the
sequence of events that takes place when I bring up PowerPoint. Is
there any way clever way to do it?

Not while PPT launches and the addin loads and runs Auto_Open, but you can
manually invoke Auto_Open again once all the shouting's done.

Another approach is to include a logging routine that you can write to as many
times as needed to track what's happening during Auto_Open:

Sub Auto_Open()
WriteToLog("Auto_Open: entry")
' dim variables etc
WriteToLog("Auto_Open: About to do stuff")
' do stuff

and so on
 
Back
Top