Limited viewing

[Nicstephrivera]

Hello All,

I am trying to limit what certain users of an Excel 2010 workbook can view, but am not sure if this is something that can be done in Excel. I know I can protect/restrict access, but this is a little different, I think. I want to be able to hide certain information from others when they open my workbook, such a certain rows/columns/worksheets, but I do not want to have them hidden from those who need to have unrestricted access. I want my boss and I to be able to open the workbook and see everything.

Is this possible? Currently, we have a sheet that links to certain information, but since this workbook updates all the time, that is not working well.

Thank you in advance if you can help!!

[ARGK]

Hi
Firstly yes it "IS" possible but it will depend on the criteria.
What I would suggest is that you set up separate worksheets within the same Workbook for each user. The you create links to the Master worksheet cells/rows/columns that that you want each user to see on their particular worksheet. You could then use a small piece of VBA code to password each sheet to restrict access to other uses.
Is this what you would be looking for?
If you need further help then let me know.
Tony