Put this line at the top of your code:
Application.OnKey "{BREAK}", ""
and this one at the bottom:
Application.OnKey "{BREAK}"
See Help for OnKey for more information.
On Mon, 21 Feb 2005 13:19:25 -0800, Al wrote:
"You might also consider disabling the user's ability to 'break' code
execution while your macro is running."
This would definitely be the optimal solution - what VB code do you use
to accomplish this?
Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!