Is There a Function To Reset Macros?

[JK]

Dear Group:

My procedures are generally written to trap errors; however, I am known to
occassionally miss one (or two, or three), which in turn causes a Run Time
Error. Not bad for me (I can fix it), but when it happens to a user of my
application, it's awful. Is there a function I can include on my toolbar
that my users can call to reset the macros until I write the patch?

Thank you in advance.

Jim Kobzeff

 

[Guest]

JK,

Macros generally can not be 'undone' you would have to write an undo or
reset for every macro

 

[JK]

ben,

Then there's no way to write a function that mimics the Run > Reset feature
we use in the code section?

Jim K

 

[Myrna Larson]

VBA is in BREAK MODE at this point. When it's in break mode, you can't run
code. So you can't use another routine that would get you out of this mode --
you can't run it.

You probably should think in terms of putting error trapping into every
routine you write, perhaps nothing more than giving an error message and
setting a global or module level variable to indicate an error. However, you
would have to modify every macro to also check that variable before
continuing.

 

[Alan]

Dear Group:

My procedures are generally written to trap errors; however, I am
known to occassionally miss one (or two, or three), which in turn
causes a Run Time Error. Not bad for me (I can fix it), but when it
happens to a user of my application, it's awful. Is there a function
I can include on my toolbar that my users can call to reset the
macros until I write the patch?

Thank you in advance.

Jim Kobzeff

Hi Jim,

See the thread starting with this post on the exact same subject from
21 Jan 2005:


Alan.