Download >>> https://tlniurl.com/1vgch0
g Depending on how many sheets you want to hide, you can proceed with one of the following methods.. This will force the Properties window to appear just below Project Explorer (please see the screenshot below).. For more information, please see How to unlock a protected workbook in Excel However, if the other (visible) sheets refer to the part of the content of this very hidden sheet (e.. If the workbook contains only very hidden sheets, you wont even be able to open the Unhide dialog box because the Unhide command will be disabled.. If you want to display absolutely all hidden sheets, then use the below one I thank you for reading and hope to see you on our blog next week.. So, if you want to make some of your worksheets much more difficult to unhide by others (e.. So, to warn your users about this limitation, wrap the above macro in an On Error block like this.. If the Properties window is already there, skip this step:) Repeat the above steps for other sheets if necessary and close the Visual Basic Editor window when finished.. For more information, please see How to protect a workbook in Excel To check this, please go to the Review tab Changes group, and have a look at the Protect Workbook button.. g VeryhiddenSheetA1), then the very hidden sheet becomes unprotected, does it Everybody else can add a new formula (VeryhiddenSheetA2) to get its content.. This will open the Visual Basic Editor with the Project Explorer window in the top-left panel displaying a tree of all open workbooks and their sheets.. All you have to do is right-click any visible worksheet, click Unhide, and select the sheet you want to view.. If someone knows the name of a very hidden sheet, they can get its content with a formula.. And many of these sheets are hidden in it, I can not unhide them Could you tell me what are the steps to save this file with hidden sheets and send it to others without the danger of being visible.. Where on earth could that sheet be Simply, it is very hidden As a matter of fact, there are two levels of worksheet hiding: hidden and very hidden.. This will prevent unhiding both hidden and very hidden sheets as well as hiding, renaming, moving, or deleting worksheets.. If it is highlighted, the workbook is protected, and you need to remove the protection first.. As you may remember, its not possible to hide absolutely all worksheets in an Excel file (whether you are making them hidden or very hidden), at least one sheet should remain in view.
Comments