I want to display a userform and make the underlying excel file invisible which I have managed. However in the windows task manager and the windows menu bar no instance of excel appears. Is there anyway of displaying that the application is open (as the userform is displayed) but not the worksheet?
[vba]
Application.Visible = False
[/vba]
Last edited by Bob Phillips; 05-08-2009 at 06:48 AM.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thats what I have done however as per the initial post when you go into task manager it appears that excel is not running but it is in the background. The solution I am trying to work out is how to hide the open spreadsheet but still be aware that excel is running.
I do not believe you are going to hde this in task manager, leastwise not under processes tab.
I do believe it is there so that amongst other things, you can spot junk you downloaded w/o knowledge; as well as to spot what IS running in the background...
Hope this helps,
Mark
Something like this maybe...
[VBA]Application.WindowState = xlMinimized[/VBA]
Hope this helps
Posting Permissions
Reply With Quote
