Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a wb with many UDFs and sheets, modules, forms etc. When I use the step by step debug (F8 key), sometimes the step don't jumps to the following statement of the routine but to some statement of a UDF. I'ld like to know if this is a correct behaviour or it's a sign of some defects hidden in the procedure. Apart these jumps that I see only debugging, apparently the procedure performs correctly. I'ld like, however, to know if these jumps must (or can) be avoided. I thought, for example, to place a pair of Application.EnableEvents (False/True) at the beginning and at the end of every routine/function, but I am not sure. Thanks, Emiliano -- eggpap Excel 2003 on Vista HP System - can use VBA ------------------------------------------------------------------------ eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50276 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tab Jumps 13 Cells when hit | Excel Discussion (Misc queries) | |||
On save excel jumps to another worksheet. How to fix VBA code? | Excel Programming | |||
Scoll bar jumps to top | Excel Discussion (Misc queries) | |||
Autofilter jumps to end of row, why? | Excel Discussion (Misc queries) | |||
Sub unexpectedly jumps to another sub | Excel Programming |