Jan 26 2022 07:00 AM
Hello,
I have a workbook with sensitive data on sheet 1, and sanitised data from Sheet 1 in sheet 2
I have 2 groups of users. Group 1 needs to be able to see all the sheets, whilst Group 2 should only see sheet 2.
Is it possible to have this on a sharepoint hosted excel workbook?
I have tried the Hide function which can be undone easily, as well as VeryHidden on VBA but this hides the sheet for all users rather than just one group.