Hide "Excel" when running VB

[Old Car]

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

[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

"Old Car" wrote:

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

[Tom Ogilvy]

At the start of your code
Application.Visible = False

At the end of your code
Application.Visible = True

--
Regards,
Tom Ogilvy

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

[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



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

[paul]

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" <nospam@nospam.com> wrote in message
> news:rAuce.73$k01.46@trnddc03...
> > Is there a way to hide "Excel" when its VB code is running?
> > Thanks.
> >
> >
>
>
>

[Robert Bruce]

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.