View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Al[_17_] Al[_17_] is offline
external usenet poster
 
Posts: 5
Default Close Excel if macro stopped

Unfortunately, I was still able to break out the macro using the Esc
key. Do I need something add'l to disable Esc?

Thanks.


I followed this:

Put this line at the top of your code:

Application.OnKey "{BREAK}", ""

and this one at the bottom:

Application.OnKey "{BREAK}"





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!