Hide "Excel" when running VB
 

Is there a way to hide "Excel" when its VB code is running? Thanks.

application.visible = false

Careful with this though. Make sure you have proper error handling. If your
code crashes... Your excel will not come back...

HTH

"Old Car" wrote:

Is there a way to hide "Excel" when its VB code is running? Thanks.

At the start of your code
Application.Visible = False

At the end of your code
Application.Visible = True

--
Regards,
Tom Ogilvy

"Old Car" wrote in message
news:rAuce.73$k01.46@trnddc03...
Is there a way to hide "Excel" when its VB code is running? Thanks.

Do you mean to hide the entire application? If so, use

Application.Visible = False
' your code here
Application.Visible = True

If you mean to simply hide the interim results of a VBA procedure
while it is running, use

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Old Car" wrote in message
news:rAuce.73$k01.46@trnddc03...
Is there a way to hide "Excel" when its VB code is running?
Thanks.

why dont you just minimize the excel window?
--
hope this helps
Paul


"Chip Pearson" wrote:

Do you mean to hide the entire application? If so, use

Application.Visible = False
' your code here
Application.Visible = True

If you mean to simply hide the interim results of a VBA procedure
while it is running, use

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Old Car" wrote in message
news:rAuce.73$k01.46@trnddc03...
Is there a way to hide "Excel" when its VB code is running?
Thanks.

Roedd <<paul wedi ysgrifennu:

why dont you just minimize the excel window?


There's a difference between <<hiding and <<crouching down really small
and hoping that no one spots you ;-)

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.