Is There a Function To Reset Macros?
 

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

Is There a Function To Reset Macros?
 

JK,

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

"JK" wrote:

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

Is There a Function To Reset Macros?
 

ben,

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

Jim K

"ben" wrote in message
...
JK,

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

"JK" wrote:

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

Is There a Function To Reset Macros?
 

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.


On Wed, 02 Feb 2005 00:39:13 GMT, "JK" wrote:

ben,

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

Jim K

"ben" wrote in message
...
JK,

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

"JK" wrote:

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

Is There a Function To Reset Macros?
 

"JK" wrote in message
news:kCRLd.44$Dc.15@trnddc06...

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.