Microsoft KB Archive/883941

= A workbook that contains a Hidden attribute is no longer hidden when you close the workbook in Microsoft Excel =

Article ID: 883941

Article Last Modified on 6/12/2006

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-





SYMPTOMS
In Microsoft Excel, when you open and then close a workbook that contains a Hidden attribute, the Hidden attribute is disabled. And, the workbook is no longer hidden.

Note You do not have to save changes to the workbook to experience this behavior.



CAUSE
This behavior occurs if the following conditions are true:
 * The File is ready for archiving attribute is disabled.
 * The Hidden attribute is enabled.



WORKAROUND
To work around this behavior, do not disable the File is ready for archiving attribute in the properties of the Excel workbook. When you do this, the Excel workbook remains hidden.



MORE INFORMATION
To view the attributes of an Excel workbook, right-click the workbook in Windows Explorer, and then click Properties.

For more information about similar behavior that occurs with the properties of an Excel workbook, click the following article number to view the article in the Microsoft Knowledge Base:

826741 Excel changes Modified date and time when you open the workbook

Additional query words: excel2003 excel2k3 excel11 xl2003 xl2k3 xl11 excel2002 excel2k2 excelxp excel10 xl2002 xl2k2 xlxp xl10 excel2000 excel2k excel9 xl2000 xl2k xl9 excel97 excel8 xl97 xl8

Keywords: kbtshoot kbproperties kbexpertisebeginner kbprb KB883941

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.