How to Protect Individual Excel Worksheets and User Ranges
Question details
The user wants to set up separate password protection for individual hyperlinks or cells so that each collaborator can only access and view their specific assigned worksheet.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook where multiple users need restricted, exclusive access to their respective worksheets without seeing others' data.
- Observed behavior
- Excel does not natively support separate password protection for individual hyperlinks or cells to restrict worksheet access securely per user.
Check if your files are stored on a cloud platform like OneDrive, SharePoint, or Teams, as co-authoring environments can disable or bypass certain VBA-based protection methods.
Use Separate Workbooks and Combine with Power Query
The most secure and reliable method is to give each user their own separate workbook and compile the data centrally using Power Query.
Since Excel cannot securely lock viewing access to specific sheets via hyperlinks in a single shared workbook, splitting the data into individual files ensures absolute privacy and access control.
Create a separate Excel workbook for each team member and distribute them accordingly. You can encrypt each file with a password via File > Info > Protect Workbook > Encrypt with Password if needed.
Save all the completed individual workbooks into a single dedicated folder on your local drive or shared network.
Open a new master workbook. Go to the Data tab, click on 'Get Data', select 'From File', and then choose 'From Folder'. Select the folder containing all the individual workbooks.
In the Power Query window, click 'Combine & Transform Data' to merge the submissions into a single master table, then click 'Close & Load' to bring the consolidated data into your master workbook.
Restrict Worksheet Access Using VBA Macros
Use Visual Basic for Applications (VBA) to prompt for passwords and unhide specific sheets based on user input.
Manage Your Spreadsheets Securely with WPS Office
While native per-hyperlink password protection isn't available in standard spreadsheet software, WPS Office provides robust worksheet protection and file encryption for free. It is a lightweight, highly compatible alternative for managing your daily workflow securely.
- 1. Download and Install: Visit the official WPS website to download WPS Office for free and install it on your computer.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open your existing Microsoft Excel files without losing any formatting or data.
- 3. Apply Protection: Navigate to the Review tab to easily utilize WPS Spreadsheet's built-in Protect Sheet and Protect Workbook features.

Frequently Asked Questions
Can I set different passwords for different sheets in the same Excel workbook?
Yes, you can protect each worksheet individually with a different password by going to the Review tab and clicking Protect Sheet. However, this only prevents editing; any user who opens the workbook can still view the data on those sheets.
Does the 'Allow Edit Ranges' feature restrict users from viewing the data?
No. The 'Allow Edit Ranges' feature lets you specify who can edit specific cells by requiring a password, but it does not hide the cells. Anyone with access to the workbook can still see the contents of those ranges.
Why doesn't VBA macro protection work well on OneDrive or SharePoint?
Excel for the Web and the co-authoring environment in OneDrive, SharePoint, and Teams do not fully support VBA macros. If users open the file in a web browser, the VBA code designed to hide or unhide sheets will not run, which can expose all hidden data.
Is Power Query available in older versions of Excel?
Power Query is built directly into Excel 2016 and newer versions under the Data tab (labeled as 'Get & Transform'). If you are using Excel 2010 or 2013, you must download and install Power Query as a separate free add-in from the official Microsoft website.




