I am helping to manage excel contributions data for a non profit.
I have an excel document that has various Excel tabs. Each tabs contains account history of all donations for each member.
I need to accomplish the following, please advise how to go about it with references as necessary( I am good in excel but not in Macros, Vbasic etc).
1. I want to be able to send the locked excel file to each member or donor
2. When each donor or member enters their unique password, they should only see the tab that has their contributions history.
3. The member should not be able to see any of the other tabs.
Please advise how to accomplish this.
Thanks
I have an excel document that has various Excel tabs. Each tabs contains account history of all donations for each member.
I need to accomplish the following, please advise how to go about it with references as necessary( I am good in excel but not in Macros, Vbasic etc).
1. I want to be able to send the locked excel file to each member or donor
2. When each donor or member enters their unique password, they should only see the tab that has their contributions history.
3. The member should not be able to see any of the other tabs.
Please advise how to accomplish this.
Thanks