Yes, the setting is at the "Excel" level.

I don't believe it will change the behavior in a regular module - at least I
have not noticed a problem.

--
Regards,
Tom Ogilvy


"Susan" wrote in message
ups.com...
john - para. #1 - yes, the line is not highlighted but it's not just a
style difference, it literally ends the code & you can't continue
except to start over from "option explicit".

tom - yes, now i get the "debug" button if i change that option.
but will that work for a regular module, too, or will i have to change
it back to "break on unhandled errors" again? the options are set for
excel as a whole, not per workbook, i believe.
thank you!
susan


On Feb 13, 12:01 pm, "Tom Ogilvy" wrote:
What are your options in tools=Options in the VBE under the general tab.

Under Error trapping, try clicking "Break in Class Module" rather than
"Break on Unhandled errors"

--
Regards,
Tom Ogilvy

"Susan" wrote in message

oups.com...



when i step thru a code in a module, & it runs into an error, it lets
me choose a button "Debug." then i can go into the code & try several
different things without exiting the code (helpful for a learn-as-you-
go person such as myself).
however, when i step thru a code for an option button_click in a
worksheet, & it runs into an error, it completely kicks me out & won't
let me debug (just get buttons "OK" & "Help"; no "Debug").
neither code has error handling in it (mea culpa).
why is this?
thanks
susan- Hide quoted text -

- Show quoted text -