VBA - Open certain sheets based on a range

[philipk55]

Hi there,

I'm looking for advice on the best way to go about constructing a module to get my desired result. I have a commissions file that i want managers to be able to go in and review the commissions. Each manager will have a username and password.

Each manager will require access to different sheets which may change over time as employees come and go. i have a table with the managers name in column A, the employee's in column B and the sheet name in column C. Any suggestions on VBA code that upon successful password input it will open up each sheet in column C that matches back to the managers name in column A?

Or is there a better/easier way of laying this out?

Thanks,

Philip

 

[dmt32]

Hi,
Have a look here:https://www.mrexcel.com/forum/excel...word-protect-viewing-multiple-worksheets.html
with solution I provided for another with a similar requirement to yours.

Solution uses network username to display their sheets which avoids entering passwords & hopefully, you can adapt to meet your specific project need.

Be mindful that Excel is not a secure platform & any of your users that have good working knowledge of Excel can access the other worksheets.

Hope Helpful

Dave