Macro Cannot Determine If Sheet Is xlVeryHidden
Article ID: 128373
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q128373
SYMPTOMS
In Microsoft Excel 5.0 for Windows, you can set the Visible property of a
sheet to True, False, or xlVeryHidden. However, you may not be able to
differentiate whether or not an invisible sheet is "Very Hidden" or just
"Hidden" (false). In either case, the return value of the Visible property
for the sheet is False.
STATUS
Microsoft has confirmed this to be a problem with Microsoft Excel version
5.0 for Windows. This problem has been corrected in Microsoft Excel version
5.0c for Windows.
Additional query words: 5.00c XL5
Keywords: kbprogramming KB128373