Thread: Error Trapping
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
AG[_9_] AG[_9_] is offline
external usenet poster
 
Posts: 16
Default Error Trapping

Thanks for the reply and link Per,

That link is about Access. I do a lot of Access work and regularly use
Application.GetOption, etc.

My question, however, is for an Excel project.
Excel does not seem to have an equivalent to Application.GetOption or
Application.SetOption like Access.

--

AG
Email: npATadhdataDOTcom


"Per Jessen" wrote in message
...
Hi

Look at this link, I think this is what you need.

http://www.fmsinc.com/TPapers/vbacode/Debug.asp#Intro

Best regards,
Per

"AG" skrev i meddelelsen
...
Can VBA Project Error Trapping be set via code in any version of Excel
from 2000 up?
If so, how?

I would like to insure that when my workbook opens, it is set to Break on
Unhandled Errors and not Break on All Errors.

Thanks,

--

AG
Email: npATadhdataDOTcom