XL: Visual Basic Activate Method Unhides Hidden Windows

ID: Q115775

The information in this article applies to:

• Microsoft Excel for Windows versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

SUMMARY

In Microsoft Visual Basic for Applications, the Activate method of the Windows object (Windows(1).Activate, for example) unhides a hidden workbook. However, if you use the Workbook object instead of the Windows object (Workbooks(1).Activate, for example), the hidden workbook will remain hidden.

MORE INFORMATION

The Activate method activates the indicated object. When the object is a window, the Activate method will bring the window to the front. If the window is hidden, the Activate method will unhide the window object.

When the object is a workbook, the Activate method activates the first window associated with the workbook. However, if the workbook is hidden, the Activate method will NOT unhide the workbook object.

Neither of these procedures will run Auto_Activate or Auto_Deactivate macros (to run these types of macros, use the RunAutoMacros method).

Additional query words: 5.0 5.0a 5.0c 7.0 XL97 XL98 XL7 XL5 unhide display select

Keywords          : kbprg kbdta SynFnc PgmOthr KbVBA 
Version           : WINDOWS:5.0,5.0c,7.0,7.0a,97; MACINTOSH:5.0,98
Platform          : MACINTOSH WINDOWS
Issue type        : kbinfo

Last Reviewed: January 2, 1999