Hello,

During system testing of my Excel 97/VBA, I have discovered the following bug:

I have a modal UserForm which controls the Active Worksheet (which is underneath the UserForm). I click a Save button to copy & save the Active Worksheet into another Workbook.

Here's the bug: When control returns back to my App, the UserForm is still there but in a modeless state. I can access the Worksheet - scroll, type into cells, etc. This must not happen, the Worksheet must always be controlled through the UserForm.

How do I set control back to the UserForm and disable direct access to the Worksheet after returning from the SaveAs routine?

Thank you,
CyberJar