|
| Posted By |
Message |
|
|
Need Excel Help!!
Hiiii
I am looking to password protect a column in Excel - so when someone wants to edit just that column a, "enter password" prompt displays....
Can anyone help?
Thanks!
|
Posted 10/3/14 11:26 AM  |
| |
|
Long Island Weddings
Long Island's Largest Bridal Resource |
kiki1103
LIF Infant
Member since 7/10 313 total posts
Name:
|
Re: Need Excel Help!!
You would have to right click on the entire column and hit 'format cells' and then go to the protection tab and make sure 'locked' is checked. Then go to the other columns and do the same thing and uncheck the 'locked'. You would then need to go ahead and Protect the sheet by going to the Review tab and clicking 'Protect Sheet'. You can input a password on the box that comes up. Every time someone tries to edit that column a warning will display that they need to first unprotect the sheet. The columns which are unlocked will not display that warning HTH!
|
| Posted 10/3/14 11:41 AM |
| |
|
BabyHopes2
LIF Adult
Member since 4/13 1058 total posts
Name:
|
Re: Need Excel Help!!
- Highlight the column that CAN be edited
- Go to Review > Allow users to edit ranges
- Click on NEW (the colum/row cells will show)
> OK > Apply > Protect Sheet
- The top 2 check boxes should be checked off
- Type in a password, which they will ask twice.
That should be it!
|
| Posted 10/3/14 11:42 AM |
| |
|
|
|
Re: Need Excel Help!!
Yes - that I did - but I was hoping for a password prompt right there when a cell in that column is clicked... instead of having users go thru the steps to unprotect the sheet
|
| Posted 10/3/14 11:45 AM |
| |
|
|
|
Re: Need Excel Help!!
NM I got it!!
|
| Posted 10/3/14 12:11 PM |
| |
|
Potentially Related Topics:
Currently 852027 users on the LIFamilies.com Chat
|
