Sunday, September 11, 2011

How to Unhide a Very Hidden Sheet in Excel 2003


1. Open a workbook that you wish to unhide. Press 'Alt' 'F11' to open Visual Basic Editor.
2. Click 'View,' then click 'Project Explorer.' Click 'View' and click 'Properties' to open the 'Project Explorer' and 'Properties' windows that will give you a view of the very hidden worksheets.
3. Select the very hidden sheet in the 'Project Explorer' window and find the very hidden sheet in the 'Properties' window within the 'Visible' tab. Under the 'Properties' window, make the very hidden worksheet visible by selecting this code in the box '-1 --- xlSheetVisible.' You have now unhidden a very hidden sheet in Excel 2003.

Blogger news