Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
AlexandraPopa pe Simpatie
 | Femeie
25 ani
Bucuresti
cauta Barbat
25 - 39 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2186
|
|
0. Open the desired sheet with the ranges you want to password protect
1. Go to the REVIEW ribbon - click Allow Edit Ranges (it might have a bit different name depending on your Excel version)
2. Click the New button
3. Change the Title to whatever you want
4. Set the range of cells in the Refers to cells field
5. Add the Range password, then click OK
6. Reenter password, then click OK
7. Repeat steps 2-6 for all your desired ranges
8. Click the Protect Sheet button on the bottom left of the "Allow Users to Edit Ranges" box
9. Add a master password for yourself (or the person who will be able to edit anything in the sheet), then click OK
10. Reenter the master password, then click OK
Now you can put this file on the intranet and give each user the password for their designated range of cells.
Source:
Title is: How to unlock certain cells on a protected Excel sheet
_______________________________________
|
|
| pus acum 2 ani |
|