Get in DEBUG mode on workbook open

[Anthony Fok]

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

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

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

[TommySzalapski]

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

[reddog9069]

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

[seisman]

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

[TommySzalapski]

You lose breakpoints when you close the file.

[Anthony Fok]

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