How to restrict access to worksheets per user

[Legacy 374719]

Hi guys, I was wondering whether you could help, I have a workbook with 10 different sheets, that I share with 9 other people, First sheet is what everyone can see, then each has their own work sheet they work with. I need to find a way to restrict access and visibility of other sheets. so that user 1 can see sheet 2 only, user 2 can see sheet 3 only and so on. And lastly I'd like a super user, myself, who can see all sheets. Can anyone advice how to achieve this with VBA?

 

[Tahas]

Hey Gallen,
I was looking for the solution and found your post. This code is working very good.
One issue I am facing. When the workbook is opened in excel online, all the sheets are visible and users can view all the sheets.
Any work around for this issue ?
Regards,
Arjun Mehta

Hey Arjun, unfortunately, this doesn't work in cloud as macros are disabled in cloud (Teams, SharePoint, Excel Online).
Taha

 

[Tahas]

Another way is to do this is to Append all the sheets into one table using Power Query. Here is a link to show you how easy this is.

https://www.myonlinetraininghub.com/power-query-consolidate-excel-sheets

Thanks to alansidman for his help. I used his advise and even improved by linking to Power BI dashboard.

Regards,
Taha