Display specific worksheets when opening Workbook based on Windows credentials

Hello,

I have two different trackers that hold information but a lot of the information is duplicated.
One of the trackers is sent to other analysts in the department but the other isn't.

I want to try to and merge both the trackers. Is there a way that I can display certain worksheets when the tracker is opened based on the users Windows credentails.

So if NOT user1 then only worksheets 1 - 3 is displayed.
Not sure if it will makes a difference but there is Win7 & Win10 users.


Thank you in advance.

With Environ("Username")

Please Login or Register  to view this content.

Hi, thanks for your quick reply.
At the risk of looking stupid, could you please explain this code. Is the letter 'j' and the number '4' significant, does it have to be 'j' and '4'.?
What is the second line doing.?

(apologies if this appears twice, typed once and hasn't appeared on this feed).

Thank you.

Just try it.