Macro Cannot Determine If Sheet Is xlVeryHidden

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q128373

Expand all | Collapse all

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.

APPLIES TO

Microsoft Excel 5.0 Standard Edition

Back to the top

kbprogramming KB128373

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top