Excel window freezes when using Forms

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.

JKwan
07-17-2005, 10:41 PM
if you use this command:
application.visible = false ' this will hide Excel

When you exit your app, turn visible back on.

Sparkie
07-18-2005, 06:41 AM
That worked so much nicer than the way I was trying to fix the issue. Thankyou.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum