Hide "Excel" when running VB

J

Jim Thomlinson

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
 
T

Tom Ogilvy

At the start of your code
Application.Visible = False

At the end of your code
Application.Visible = True
 
C

Chip Pearson

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
 
R

Robert Bruce

Roedd said:
why dont you just minimize the excel window?
Click to expand...

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.
 
Top