| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding a workbook
Hello,
What is the VBA code to hide a wookbook while running a VBA macro? -- Regards, Jeff ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
|
#2
|
|||
|
|||
|
If you record a macro when you hide the active Window, you'll get code like:
ActiveWindow.Visible = False Jeff wrote: Hello, What is the VBA code to hide a wookbook while running a VBA macro? -- Regards, Jeff ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
| keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
