Is there a way to personalize the view of my sheet for certain users? Not all users need to see all columns so wondering if there is a way to have a tailored view show per user. Similar to programming your car for driver 1 and driver 2 to their seat/mirror preferences. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Personalized views for different users
- Thread starter DD BIW
- Start date
Logit
Well-known Member
- Joined
- Aug 31, 2016
- Messages
- 4,848
You would create a "log-in" sheet that displays when the workbook first opens. Depending on the log-in credentials, the user is shown 'their sheet / sheets' only. Those sheets would be designed specifically for the individual.
It is assumed you would have a 'Master Sheet' to display all data, and that sheet would be filtered to the individuals personal needs.
It is assumed you would have a 'Master Sheet' to display all data, and that sheet would be filtered to the individuals personal needs.
Upvote
0
