Shared Excel workbook, hidden sheets

Occasional Visitor

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.

0 Replies