Get in DEBUG mode on workbook open
 

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

--
Anthony Fo
-----------------------------------------------------------------------
Anthony Fok's Profile: http://www.excelforum.com/member.php...fo&userid=1683
View this thread: http://www.excelforum.com/showthread.php?threadid=39092

Get in DEBUG mode on workbook open
 

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

--
TommySzalapsk
-----------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556
View this thread: http://www.excelforum.com/showthread.php?threadid=39092

Get in DEBUG mode on workbook open
 

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

Get in DEBUG mode on workbook open
 

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

--
reddog906
-----------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...fo&userid=2445
View this thread: http://www.excelforum.com/showthread.php?threadid=39092

Get in DEBUG mode on workbook open
 

You lose breakpoints when you close the file

--
TommySzalapsk
-----------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556
View this thread: http://www.excelforum.com/showthread.php?threadid=39092

Get in DEBUG mode on workbook open
 

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


--
Anthony Fok
------------------------------------------------------------------------
Anthony Fok's Profile: http://www.excelforum.com/member.php...o&userid=16832
View this thread: http://www.excelforum.com/showthread...hreadid=390927