I have an application that is controlled from a UserForm. The user only sees the form - not the worksheets in the background. I start the application with.....
Private Sub Auto_Open()
Application.Visible = False
There seems to be some unfortunate side effects that I was not expecting... for example...
If I open my application - the UserForm is sitting there - just fine. If I now open another Excel spreadsheet that opens fine too. However when I close that spreadsheet it wants to close my application too! Not what I want at all...
If I have a spreadsheet open, and it has a cell selected for editing then my application won't open until the editing is complete. And then my application will open, but the spreadsheet becomes hidden.
Hmmm... There must be a better way.
How do I fix this?