Visual Basic Activate Method Unhides Hidden Windows (115775)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q115775 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).
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbinfo kbProgramming KB115775 |
|---|
|