Unhide Very Hidden Sheets in Excel

Aim: To unhide Very Hidden Sheets in Excel.

As part of a recent data warehouse project, I had to extract data from an Excel spreadsheet (yuck, I know!). Based on some of the formulae in the visible sheets, it was apparent that there was another sheet hidden in the file. However, it was not possible to unhide the sheet via the Home tab on the ribbon, which indicated that it was a Very Hidden Sheet.

01_BasicUnhideSheet

Instead, click Alt+F11 to open the “Visual Basic for Applications” Editor. If they are not already visible, open the Project Explorer & Properties Window from the View menu. In the Project Explorer, highlight the hidden sheet. In the Properties Window, you can see that the Visible property is set to “2 – xlSheetVeryHidden”. To unhide the sheet, set the property to “-1 – xlSheetVisible”.

02_VBEditor

Save & close the Editor. The sheet will now be visible in the spreadsheet.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!

%d bloggers like this: