Fellas,
i am fairly new to excel and was wondering if there is any way to password protect individual tabs in a worksheet?
basically we want to display lots of data about people that is private and shuold only be viewed by that specific person.
There is 2 ways i thought we could do this:
Have each persons data in a seperate tab, and password protect the tab,giving each person a password for their tab so only that person can read there data in that tab
or
somehow set usernames and passwords so when a certain person logs in it only displays there data?
any thoughts or ideas would appreciated
Thanks
Bookmarks