S
Sssuperdave
I've been asked to troubleshoot a workbook for another area of my company -
the problem they are having is quite strange. The workbook is a fairly
complicated tool that inwith a number of forms and inputs, and interacts
with a WebFocus table, that will ultimately be used by a number of 3rd
parties.
After filling in a particular form excel will always completely crash,
giving the "Do you want to send an error report to Microsoft..." dialog. It
is quite strange because at teh time of the crash this form is doing nothing
special. It just copies some values from the form to a worksheet and then
calls another form.
Here is the strangest part. The VB code is protected. If I unprotect the VB
code prior to opening the form, the error does not happen, and the workbook
works flawlessly. Again, that is unprocting the VB code itself, not the
workbook or any worksheets. I haven't been able to find any other way to
keep the error from happening.
The version of excel that I'm using is 2003. Any ideas?
the problem they are having is quite strange. The workbook is a fairly
complicated tool that inwith a number of forms and inputs, and interacts
with a WebFocus table, that will ultimately be used by a number of 3rd
parties.
After filling in a particular form excel will always completely crash,
giving the "Do you want to send an error report to Microsoft..." dialog. It
is quite strange because at teh time of the crash this form is doing nothing
special. It just copies some values from the form to a worksheet and then
calls another form.
Here is the strangest part. The VB code is protected. If I unprotect the VB
code prior to opening the form, the error does not happen, and the workbook
works flawlessly. Again, that is unprocting the VB code itself, not the
workbook or any worksheets. I haven't been able to find any other way to
keep the error from happening.
The version of excel that I'm using is 2003. Any ideas?