Sparkie
07-17-2005, 09:36 PM
When using forms in EXCEL VB the excel sheet freezes in the background. I have found a partial fix to this by adding "Application.WindowState = xlMinimized prior to the UserForm1.Show command, then, Application.WindowState = xlNormal afterward.
This hides the excel worksheet, but I have to click on the EXCEL icon in my taskbar to launch the form onto my desktop.
I am looking for the command that tells the form to appear on my desktop.
This hides the excel worksheet, but I have to click on the EXCEL icon in my taskbar to launch the form onto my desktop.
I am looking for the command that tells the form to appear on my desktop.