How to protect excel workbook from editing without password

How to set passwords to protect individual worksheets by users in Excel?

Author: XiaoyangLast Modified: 2024-12-05

In Excel, you can set different passwords for different sheets, this means that one user could make changes to one worksheet using one password, and another could use a different password to make changes to another worksheet.

But, sometimes, you just only want each user to be able to view and access their own sheet. Is this possible to be solved in Excel?

---

To protect each worksheet individually and limit access to the worksheets by users, please apply the below VBA code:

1.

How to remove password protect an excel file

Open a new workbook, and create a new sheet named as “Main”, see screenshot:

2. Then, press Alt + F11 keys to open the Microsoft Visual Basic for Applications window, double click ThisWorkbook from the left Project-VBAProject pane to open a blank code module, and then copy and paste the following VBA code into the code window, see screenshot:

VBA code: Set passwords to protect individual sheets by users

3.

Then, put the cursor at the end of the Private Sub Workbook_Open(

password protect single sheet in excel

how to protect specific sheets in excel