Get in DEBUG mode on workbook open

[Anthony Fok]

is there a way to get into the debugger just as i open excel (and enabl
macros)

i am currently trying to debug a file but the error occurs in th
Workbook Open method.

i cant figure out a way to get into the debugger before the erro
happens, is this even possible? thanks

 

[TommySzalapski]

The easiest way I can think of is to rename your workbook_open macro (s
that it won't run on open) open it and the debugger and run the macr
manually (using f8 or the little play button) There may be a les
clumsy solution, but this will work

 

[seisman]

Try puttinga STOP command at the beginning of the Workbook Open method.
Seisman

 

[reddog9069]

as long as you do not have a password on the macros then just open i
and put a breakpoint on the first line of the workbook open method the
when the workbook opens it should take you into debug mode

 

[TommySzalapski]

You lose breakpoints when you close the file

 

[Anthony Fok]

thanks for the tips, i'll give it a shot