Can I set different passwords for different sheets

Asked By 0 points N/A Posted on -
qa-featured

This is the scenario. I have a Excel document with nearly 30 sheets. Each sheet belongs to a customer and the data is readable by customer. I am maintaining data of all customers in same Microsoft Excel document. Whenever the customer asks data, I copy his/her sheet into a new document and send it to them. But, sometimes I do mistakes and sometimes it feels annoying. Isn’t there a way to password protect individual sheets with individual password so that I can send full document to them, but still they will be able to see only there sheet. I will share th passwords with the customers respectively. Thank you for your kind support.

SHARE
Answered By 0 points N/A #194309

Can I set different passwords for different sheets

qa-featured

1.   Open a blank worksheet in Excel 2007.

2.   On the Review tab, click Allow Users to Edit Ranges.

3.   In the Allow Users to Edit Ranges dialog box, click New.

4.   In the New Range dialog box, click Collapse Dialog, select the range B2:B6, and then click Collapse Dialog again.

5.   In the Range password and Confirm Password boxes, type rangeone, and then click OK.

6.   Repeat steps 3 through 5. However, select the range D2:D6, and then type rangetwo as the password for that range.

7.   In the Allow Users to Edit Ranges dialog box, click Protect sheet.

8.   In the Password to unprotect sheet box, type ranger, and then click OK two times.

Note Retype the password when you are prompted.

9.   Select cell B3, and then start to type Dataone.

Note When you start to type, the Unlock Range dialog box appears.

10.  Type rangeone in the Enter the password to change this cell box, and then press ENTER.

 

Solution 2

1.   Open a blank worksheet in Excel 2007.

2.   On the Review tab, click Allow Users to Edit Ranges.

3.   In the Allow Users to Edit Ranges dialog box, click New.

4.   In the New Range dialog box, click Collapse Dialog, select the range B2:B6, and then click Collapse Dialog again.

5.   In the Range password box, type rangeone, and then click OK two times. 

Note Retype the password when you are prompted.

6.   Repeat steps 3 through 5. However, select the range D2:D6, and then type rangetwo as the password for that range.

7.   In the Allow Users to Edit Ranges dialog box, click Permissions, and then click Add in the Permissions for Range2dialog box.

8.   In the Select Users, Computers, or Groups dialog box, type Everyone, and then click OK two times.

9.   In the Allow Users to Edit Ranges dialog box, click Protect sheet, type ranger in the Password to unprotect sheet box, and then click OK two times.

Note Retype the password when you are prompted.

10.  Select cell B3, and then start to type Dataone. 

Note A password is required to edit the cell.

11.  In the Unlock Range dialog box, click Cancel.

12.  Select cell D3, and then type Datatwo. 

Also see here

Answered By 572230 points N/A #310506

Can I set different passwords for different sheets

qa-featured

Unfortunately, what you want to do is not possible. You cannot protect individual sheets on your workbook from getting viewed by unauthorized users. When you open a Microsoft Office Excel workbook that contains several worksheets for different people or customers, all sheets are visible and accessible.

You can protect the file with a password to prevent unauthorized users from viewing the contents or opening the file but this doesn’t protect individual sheets. All are visible once the file is opened. There are options to protect individual sheets from accidental modifications but there is no option to prevent the sheet from getting viewed.

Anyway, to protect the workbook with a password, start Microsoft Office Excel then open your file. Now, once the file is opened, click the Office button or “File” then select “Saves As” or press F12 to bring up the Save As dialog. In the Save As dialog, click “Tools” on the bottom left corner then select “General Options”. Enter the password for open and modify.

You can use the same password for both fields but you can also set a different password for the other one. Click “OK” then save the file to apply the new password. After this, you will be prompted with a password every time you open the file.

Login/Register to Answer

Related Questions