![]() In the Microsoft Visual Basic for Applications window, click Insert > Module to open an empty module, and then click Tools > VBAProject Properties, see screenshot:ĥ. After making the worksheet veryhidden, you can set a password to protect it. And then in the Project-VBAProject pane, choose the worksheet that you want to hide, and in the Properties pane, click the drop down list from the Visible section to select xlSheetVeryHidden option, see screenshot:Ĥ. In the Microsoft Visual Basic for Applications window, click View > Project Explorer and Properties Window to display their panes.ģ. Open your workbook, and hold Alt + F11keys to open the Microsoft Visual Basic for Applications window.Ģ. Normally, you can use the VeryHidden function to hide the worksheets first, and then set a password for them, please do as following steps:ġ. ![]() Protect multiple worksheets at once with Kutools for Excel Set password to protect hidden sheet with VBA code Set password to protect hidden sheets with VeryHidden function ![]() Do you have any ways to deal with this task quickly and easily in Excel? Now, you need to set a password to protect the hidden worksheets completely, when other users unhide them, they must enter the password. If you have a workbook which contains some important hidden worksheets, and do not allow others to unhide them. How to set password to protect hidden sheet in Excel?
0 Comments
Leave a Reply. |