Macro to Open or Activate a Sheet in Microsoft Excel

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a
• Microsoft Excel for OS/2, versions 2.2, 2.21, and 3.0

SUMMARY

When you activate a worksheet from a macro, the worksheet must first be opened. You will receive a "Macro Error at Cell: xx" if the sheet is closed.

The following macro will activate SHEET1.XLS if it is already open, or it will open and activate SHEET1.XLS if the sheet is closed.

MORE INFORMATION

Microsoft provides macro examples for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This macro is provided 'as is' and Microsoft does not guarantee that the following code can be used in all situations. Microsoft does not support modifications of the code to suit customer requirements for a particular purpose.

1. Enter the following into a macro sheet:

         A1: ActivateSheet
         A2: =ERROR(FALSE)
         A3: =IF(ISERROR(ACTIVATE("SHEET1.XLS")),OPEN("SHEET1.XLS"))
         A4: =ERROR(TRUE)
         A5: =RETURN()
   

2. Define the macro by selecting cell A1. Click Define Name on the Formula menu.

   The name will appear in the Name box.

3. Select Command in the Macro section at the bottom of the dialog box and click OK.

   ARTICLE-ID: Q135390
   TITLE     : XL: VB for Apps Procedure to Open or Activate a Workbook

REFERENCES

"Microsoft Excel Function Reference," version 4.0, pages 135, 225, and 24 "Microsoft Excel Function Reference," version 3.0, pages 68, 125, and 135 "Microsoft Excel Functions and Macros," version 2.1, pages 57, 65-66, 274