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. |