 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2005Hide "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 > 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  SignatureRegards, Tom Ogilvy > 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 SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com > Is there a way to hide "Excel" when its VB code is running? > Thanks. why dont you just minimize the excel window? Signaturehope this helps Paul > Do you mean to hide the entire application? If so, use > [quoted text clipped - 11 lines] > > 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>> ;-) SignatureRob 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.