PDA

View Full Version : Excel Visible/Invisible



d4vem
05-08-2009, 03:19 AM
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?

Bob Phillips
05-08-2009, 03:30 AM
Application.Visible = False

d4vem
05-08-2009, 06:16 AM
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.

GTO
05-08-2009, 06:22 AM
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

georgiboy
05-08-2009, 08:43 AM
Something like this maybe...

Application.WindowState = xlMinimized

Hope this helps