The result is a very stealthy sheet, but it's still vulnerable to savvy users who know the technique. Sheet2 is visible because (earlier) we used the Hide command from the Format menu to hide it. In fact, Excel dims the Unhide command if the only sheets hidden are very hidden sheets. Nor does Excel list Sheet3 in the Unhide dialog box. When you return to Excel, Sheet3 isn't visible. That behavior is normal, so don't let it bother you. When you do, Excel applies the property and then selects the first sheet, Sheet1, which is a bit distracting. In the Properties window, select 2 - xlSheetVeryHidden from the Visible property's drop-down list.In the Project Explorer, select the sheet you want to hide.You'll need the VBE to apply this property as follows: The average user won't even know the sheet exists, let alone know how to unhide it. I have 5 spreadsheet tabs in my Excel file and 2 of those 5 are hidden tabs (which I did by right clicking then clicked Hide) when I send the file out to others I only want those who know the password to be able to unhide the 2 hidden tabs.Ī very hidden worksheet can't be unhidden using the Excel user interface because it doesn't appear in the Unhide dialog box. Excel has a more secure setting known as 'very hidden.' From the resulting submenu, choose Hide.First, let's look at the traditional method for hiding a sheet: SEE: (TechRepublic) Fortunately, the technique is simple for you - and users won't suspect a thing. If you want a more securely hidden sheet, hide it in the Visual Basic Editor (VBE). Image: iStockphoto You can hide an sheet, but users can unhide it just as quickly.

Unhide tabs on excel for mac