Is it possible in excel to restrict view the sheets and view those persons which i had mentioned
Is it possible in excel to restrict view the sheets and view those persons which i had mentioned
Do you mean that you wish to choose from a menu of people whose names are also sheet names in your workbook, and then show only the sheets relevant to those people? If so, this will require VBA. Please confirm.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ys, people whose names i ve mentioned in the master sheets(which is hidden sheet)
OK - VBA it is, then. Thread moved.
Hi Try Below Code with sample file
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks