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!