rutgermons
asked on
excel password protect sheet
folks
how can I make a column in a excel sheet password protected ?i would like the values to be enccypted and only be accessed if a certain user can access the sheet
how can I build this into excel
how can I make a column in a excel sheet password protected ?i would like the values to be enccypted and only be accessed if a certain user can access the sheet
how can I build this into excel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Select the whole sheet and use Cell format window > Protection tab to remove the Locked tick and Hidden tick, so both check boxes blank.
Then Select the column to be protected and use the Cell format window > Protection tab to tick the locked and hidden check boxes.
Format this column with same colour font as background if you want it invisible.
Then Tools > Protection > protect Worksheet. In the list of options available, deselect the Select Locked cells option.
However, one slight flaw to this method.
The user won't be able to select the locked cells or the whole sheet but if he were to use the mouse to highlight an area which included the locked column, the contents would show in inverse colour, eg white on black rather than black on white.
Thanks
Rob H