Excel Macro to Close All Open Worksheets Except for the Macro

ID: Q66017


The information in this article applies to:


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("MACRO1.XLM")
   =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        : 

Last Reviewed: March 21, 1999