I have an Excel App that is 100% User Form driven. In fact, the end user never sees or interacts directly with Excel. Here's my problem; I want to be able to minimize and maximize the User Form with the ease that is associated with Windows applications.
I am able to minimize the form and Excel by using the QueryClose event. However, when I try to maximize the form by clicking the Taskbar, it opens up Excel and not the User Form. I can't find the event that is triggered by clicking the Taskbar so I don't know where to place the code that will automatically show the User Form once Excel is maximized.
I hope this makes sense. Can anyone help?
I am able to minimize the form and Excel by using the QueryClose event. However, when I try to maximize the form by clicking the Taskbar, it opens up Excel and not the User Form. I can't find the event that is triggered by clicking the Taskbar so I don't know where to place the code that will automatically show the User Form once Excel is maximized.
I hope this makes sense. Can anyone help?