Microsoft KB Archive/45843

From BetaArchive Wiki

Excel: Saving Hidden Worksheets or Macro Sheets


In Microsoft Excel version 2.2, 3.0 and 4.0, you can hide documents so that values can be accessed and macros can be run, but the documents themselves are not displayed.

A hidden document can be made active only through a macro and is active only while the macro is running. Since the File Save command saves the active document, a hidden document cannot be saved in the standard manner.

To save changes to a hidden file, quit Excel or hold down the SHIFT key and choose Close All from the File menu. Either of these actions closes all open documents, including hidden documents, prompting you to save changes to each one. At least one unhidden document must be open for the Close All option to be available.

Note that simply hiding a document, or changing its size or shape, does not flag the document as changed. If you close a document that has no changes other than window characteristics, Excel doesn't prompt you to save changes, and the file doesn't retain those characteristics when it is reopened. To save changes to the window characteristics of a hidden document, make some other change in the document to flag it as changed.

You can also use a macro to make changes to a hidden worksheet.


To save a worksheet as hidden, do the following:

  1. Make some change to the document (if no changes have been made, click the formula bar and press the ENTER key on the numeric keypad).
  2. From the Window menu, choose Hide. If the window characteristics of the document are password protected, you are prompted to enter a password.
  3. Hold down the SHIFT key and choose Close All from the File menu. When asked to save changes to the hidden document, select Yes. The worksheet is saved as hidden.

Alternatively, you can use the following macro to save a hidden worksheet (in this case, the worksheet is named "hidden"):



"Microsoft Excel User's Guide 1," version 4.0, page 294

"Microsoft Excel User's Guide 2," version 4.0 ,page 189

Additional query words:

Keywords :
Version :
Platform :
Issue type :
Technology :

Last Reviewed: March 15, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.