| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get in DEBUG mode on workbook open
Try puttinga STOP command at the beginning of the Workbook Open method.
Seisman |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open in form mode | Excel Discussion (Misc queries) | |||
| Locking debug mode in a macro | Excel Worksheet Functions | |||
| how open dbf in shared mode? | Excel Programming | |||
| Debug Step vs Run Mode | Excel Programming | |||
| Mysterious debug mode | Excel Programming | |||
![Anthony Fok[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
