Thread: Code Jumps
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eggpap[_5_] eggpap[_5_] is offline
external usenet poster
 
Posts: 1
Default Code Jumps


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