Error Help Needed On MyForm.Show
 

We have a worksheet that was working fine, then all of a sudden started
crashing with a very generic error, something like, "Excel has produced an
error and will close."

The workbook opens on a worksheet with just one button showing. The button
has 1 very simple line of code: Pricing.Show.

The user form "Pricing" has no initialization code of any kind, yet it now
crashes today, Monday, when it didn't crash Friday. If the VB Editor is
open, it doesn't crash and the user form opens fine. Go figure!

The error can not be trapped. It happens immediately after the button is
pushed. The Call Stack shows "(non-basic code)". What's running between the
Click event and the Show method?

Error Help Needed On MyForm.Show
 

victorcamp,

In the VBE, ToolsOptionGeneral and selecting "Break in Class Modules" will
include debugging inside the form. If you haven't already selected that, it
should help you see the error.

hth,

Doug

"victorcamp" wrote in message
...
We have a worksheet that was working fine, then all of a sudden started
crashing with a very generic error, something like, "Excel has produced an
error and will close."

The workbook opens on a worksheet with just one button showing. The button
has 1 very simple line of code: Pricing.Show.

The user form "Pricing" has no initialization code of any kind, yet it now
crashes today, Monday, when it didn't crash Friday. If the VB Editor is
open, it doesn't crash and the user form opens fine. Go figure!

The error can not be trapped. It happens immediately after the button is
pushed. The Call Stack shows "(non-basic code)". What's running between
the Click event and the Show method?