Macro Cannot Determine If Sheet Is xlVeryHidden (128373)



The information in this article applies to:

  • Microsoft Excel for Windows 5.0

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.

Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbProgramming KB128373