Shared Excel workbook, hidden sheets

Occasional Visitor



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.

0 Replies