Restrict access for certain people in excel

[Heemanee]

How do I restrict certain people from editing few columns in excel, however they beed to read the columns n should be able to use filter n sort options though. Have tried edit allow ranges options but doest seems to work for me . Appreciate any help provided.

 

[t0ny84]

Hi Heemane,

I don't know if you have found a solution that works for you. But here are a few suggestions which might assist either on their own or as a combination.

1) Have 2 Sheets

Sheet 1
This holds the data you need to show users. Hide this sheet.

Sheet 2
Visible to users. The cell data they have is just pulling the info from Sheet 1.

Example
Sheet 2 Cell A1 has =Sheet1.A1

With above you can also make a copy of Sheet 2 then have a macro that on close clears visible Sheet 2 and copies all cells from hidden Sheet 2.

2) Read Only With Password To Edit.
Depending on who has to have access to edit the spreadsheet you could set it as read only with a password for editing.

3) Lock Cells
Lock all cells and when protect sheet do locked/unlocked cells, sort, auto filter.

4) Macro
Few options would be:
- macro to disable save.
- macro to only show sheets based on password entered on opening the spreadsheet.
- macro using on close to delete Sheet 2 and replace it with a copy of hidden Sheet 2.