Excel: Saving Hidden Worksheets or Macro Sheets

SUMMARY

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.

MORE INFORMATION

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.

   =ACTIVATE("hidden")
   =SAVE()
   =RETURN()

REFERENCES

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

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