J
Jamie Chang
I have an Excel workbook that has a form I created that
automatically opens when the workbook is launched. I
have a button which allows you to close the form, when I
press that button, then click the X to close Excel and
select "No" at the do you want to save your file prompt,
I get an error that Microsoft Excel has encountered a
problem and needs to close. We are sorry for the
inconvenience. It gives you the option to report it to
the MS help desk...
The skip button unhides some columns and closes the form
as follows:
Unload UserForm1
UserForm1.Hide
Why do I get this error?
automatically opens when the workbook is launched. I
have a button which allows you to close the form, when I
press that button, then click the X to close Excel and
select "No" at the do you want to save your file prompt,
I get an error that Microsoft Excel has encountered a
problem and needs to close. We are sorry for the
inconvenience. It gives you the option to report it to
the MS help desk...
The skip button unhides some columns and closes the form
as follows:
Unload UserForm1
UserForm1.Hide
Why do I get this error?