[Missy]

I’ve been digging and can’t find an answer. I will continue to dig if someone can tell me if this is possible.

Can you set up a workbook with user specific permissions? i.e. a 10 page book that only myself and one other person can view in its entirety and four other users who can view page 1 only, page 2 only, page 3 only or page 4 only.

https://excel.tips.net/T001952_Protecting_Individual_Worksheets_by_User.html

I found this but it doesn’t seem to be working for me

Old timer,  A71'er since 2010.

Finance manager/HR manager

 

 

Licensed Massachusetts Non Reporting CPA since 2012
Finance/Admin/HR Manager

[Monkey Wrench]

well, i can look a little later, but you could always set up the pages to be completely locked, and just have different passowds for every page…but that may be annoying.

[Monkey Wrench]

that doesn't really stop the viewing though, you could lock and hide pages, for specific users, that might keep them from being able to see or get to them.

[Anonymous]

What version of Excel are you using? The link you posted is for much older versions which could be why it's not working.

[Author]

Replies