Excel: Hiding Macro Sheets Reduces Screen Redrawing

ID: Q51182

The information in this article applies to:

SUMMARY

To reduce screen redrawing operations in Microsoft Excel versions 2.20, 3.00 and 4.00, you can hide macro sheets even though they are active. You can do this in one of the three following ways:

Method 1

Use the HIDE command function in a macro.

Method 2

Save the macro sheet in a hidden state. To save a macro sheet so that it remains hidden the next time it is loaded, do the following:

  1. Make the sheet to be saved the active sheet on the display.


  2. Make some change to the sheet; for example, press COMMAND+U and press the ENTER key.


  3. From the Window menu, choose Hide.


  4. From the File menu, choose Quit, or hold down the SHIFT key and choose Close All from the File menu. When Excel asks if you want to save your changes, click Yes.


Method 3

The following is for Excel versions 3.00 and later only:

Save the macro as an add-in macro. Add-in macros function like hidden macros, but do not require a window of their own (eliminating any redrawing of the macro). To save a macro as an add-in:

  1. From the File menu, choose Save As.


  2. Click the Options button, and in the resulting list box, select Add-In. Click OK.


  3. Name the macro sheet, and click the Save button.


Additional query words: 2.20 3.0 4.00 


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 15, 1999