![]() ![]() Select the worksheet you wish to hide from the dropdown list under Properties or by single clicking the worksheet in the VBAProject window. ![]() To access Very Hidden setting, we’ll have to use the built-in Visual Basic Editor by hitting the Alt + F11 keys. If you’d like to pump the security up a notch, there is also Very Hidden mode. While hidden mode is nice, it’s not exactly ultra-secure. In the Unhide pop up window, select the worksheet to unhide and click “OK.” Note: Although you can hide multiple sheets at once, you can only unhide one sheet at a time. Or, you can right-click on any visible tab, and select Unhide. On the Home tab, click on Format in the Cells group and then under Visibility, select Hide & Unhide, then Unhide Sheet. To unhide a worksheet, you just do the opposite.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |