Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hide "Excel" when running VB
Is there a way to hide "Excel" when its VB code is running? Thanks.
|
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
How do I hide formulas in Excel cells? | Excel Discussion (Misc queries) | |||
In Excel VBA Editor, how do I hide my code from other users? | Excel Discussion (Misc queries) | |||
Excel files on local drives running from internet | Excel Worksheet Functions | |||
Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions |