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

Not knowing your code makes it impossible to answer! It might just be that
your code actually calls the UDF?
--
Hth

Kassie Kasselman
Change xxx to hotmail


"eggpap" wrote:


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

Thanks for your reply,

Kassie;181879 Wrote:
Not knowing your code makes it impossible to answer! It might just be
that
your code actually calls the UDF?

No, the UDFs are called by Excel itself not by code.
I think you can reply without seeing the code, that is very big. I ask
only if you, thanks to the experience I don't have, have ever seen a
similar behaviour.

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