Microsoft KB Archive/66017

{|
 * width="100%"|

Excel Macro to Close All Open Worksheets Except for the Macro

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0
 * Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0

-

SUMMARY
To close all open worksheets except for the macro sheet in a macro, protect the macro sheet's window prior to executing the CLOSE.ALL function.

The following is an example:

  =ACTIVATE(&quot;MACRO1.XLM&quot;) =PROTECT.DOCUMENT(,TRUE) =CLOSE.ALL =PROTECT.DOCUMENT(,FALSE) Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 5.0 5.00

Keywords :

Version :

Platform :

Issue type :

Technology :