XL: How to Close All Workbooks but One with Visual Basic Macro (147742)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q147742 SUMMARY
This article explains how to create a Microsoft Visual Basic for
Applications macro (Sub procedure) that closes all other workbooks when you
open a particular workbook.
REFERENCES
For additional information about getting help with Visual Basic for
Applications, please see the following article in the Microsoft Knowledge
Base:
163435 VBA: Programming Resources for Visual Basic for Applications
226118 OFF2000: Programming Resources for Visual Basic for Applications
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB147742 |
---|
|