How To Set Password To Protect Hidden Sheet In Excel

How to gear up password to protect hidden sheet in Excel?

If you lot accept a workbook which contains some of import hidden worksheets, and do non allow others to unhide them. At present, you need to set a countersign to protect the subconscious worksheets completely, when other users unhide them, they must enter the password. Do you have any ways to bargain with this task quickly and hands in Excel?

Set countersign to protect hidden sheets with VeryHidden office

Set countersign to protect hidden sheet with VBA code

Protect multiple worksheets at once with Kutools for Excel

---

Set password to protect hidden sheets with VeryHidden function

Commonly, you tin can use the VeryHidden function to hibernate the worksheets first, and then set a countersign for them, please practise as following steps:

1. Open your workbook, and concur Alt + F11keys to open the Microsoft Visual Basic for Applications window.

2. In the Microsoft Visual Bones for Applications window, click View > Project Explorer and Properties Window to display their panes.

3. And so in the Projection-VBAProject pane, choose the worksheet that y'all want to hide, and in the Properties pane, click the driblet down list from the Visible department to select xlSheetVeryHidden choice, encounter screenshot:

four. After making the worksheet veryhidden, you tin can set a countersign to protect it. In the Microsoft Visual Basic for Applications window, click Insert > Module to open an empty module, and then click Tools > VBAProject Properties, run across screenshot:

5. Then in the popped out VBAProject-Project Backdrop dialog box, click Protection tab, and then check Lock project for viewing box, finally, enter and confirm the countersign in the Password to view project properties department, see screenshot:

6. So click OK push button to get out this dialog, and close the Microsoft Visual Basic for Applications window.

7. Save the workbook as Excel Macro-Enabled Workbook format and close it to make the password protection accept effect.

8. Next fourth dimension, when yous open this workbook, and want to make the veryhidden sheets be visible, you are requested to enter a countersign. See screenshot:

---

Demo: Gear up password to protect hidden sheets

---

Set countersign to protect hidden canvas with VBA lawmaking

To set a countersign to protect the subconscious sheets, I tin can besides talk near a VBA code for you.

1. Hibernate ane worksheet that you desire to protect.

2. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.

3. Then choose ThisWorkbook from the left Projection Explorer, double click it to open the Module, and and then copy and paste following VBA code into the blank Module:

VBA code: Gear up countersign to protect subconscious sail

          Individual Sub Workbook_SheetActivate(ByVal Sh As Object) Dim xSheetName As String xSheetName = "Sheet1" If Application.ActiveSheet.Name = xSheetName And so     Application.EnableEvents = Fake     Awarding.ActiveSheet.Visible = Fake     xTitleId = "KutoolsforExcel"     response = Application.InputBox("Countersign", xTitleId, "", Type:=2)     If response = "123456" Then         Awarding.Sheets(xSheetName).Visible = True         Application.Sheets(xSheetName).Select     End If End If Application.Sheets(xSheetName).Visible = True Application.EnableEvents = Truthful End Sub                  

Note: In the higher up code, Sheet1 of the xSheetName = "Sheet1" script is the hidden worksheet name that you lot desire to protect, and 123456 in the If response = "123456" And then script is the countersign that y'all set for the subconscious sheet. You tin can modify them to your need.

four. Now, when you desire to show the hidden canvass, a prompt box volition pop out to let you enter the countersign. And this prompt box will appear each time, when you click to show the hidden sheet.

---

Protect multiple worksheets at once with Kutools for Excel

If you want to protect multiple selected or all worksheets of a workbook at in one case, normally, you need to protect i by one manually in Excel. But, if you take Kutools for Excel, with its Protect Worksheet utility, you can protect them with one click.

After installing Kutools for Excel, delight do every bit follows:

1. Click Kutools Plus > Protect Worksheet, see screenshot:

2. In the Protect Worksheet dialog box, all worksheets within the workbook are listed into the listing box, please choose the worksheets that you lot want to protect. See screenshot:

iii. And then click OK, in the following dialog box, delight enter your password and retype information technology over again, then click OK, another prompt box will pop out to remind you lot how many worksheets take been protected.

iv. And so click OK to close the dialogs, and all of the worksheets in the workbook have been protected with the same password.

Note: If y'all desire to unprotect all of the worksheets at in one case, yous just need to click Kutools Plus > Unprotect Worksheet, and type your password to cancel the protection.

 Download and free trial Kutools for Excel At present !

---

Related articles:

How to protect multiple worksheets at once in Excel?

How to set a password to protect the workbook?

How to protect / lock VBA code in Excel?

---

The All-time Role Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by eighty%

• Reuse: Quickly insert complex formulas, charts  and anything that you take used before; Encrypt Cells with password; Create Mailing List and transport emails...
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit big numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Forbid Indistinguishable Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
• Exact Copy Multiple Cells without changing formula reference; Machine Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
• Extract Text, Add Text, Remove by Position, Remove Infinite; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Avant-garde Sort by month/calendar week/24-hour interval, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Catechumen xls, xlsx and PDF...
• More than than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features thirty-twenty-four hour period free trial. 60-day money back guarantee.

---

Role Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
• Open up and create multiple documents in new tabs of the aforementioned window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you lot every 24-hour interval!

Source: https://www.extendoffice.com/documents/excel/2134-excel-password-protect-hidden-sheet.html

Share this post