Shared Excel workbook, hidden sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3072669%22%20slang%3D%22en-US%22%3EShared%20Excel%20workbook%2C%20hidden%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072669%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20workbook%20with%20sensitive%20data%20on%20sheet%201%2C%20and%20sanitised%20data%20from%20Sheet%201%20in%20sheet%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%202%20groups%20of%20users.%20Group%201%20needs%20to%20be%20able%20to%20see%20all%20the%20sheets%2C%20whilst%20Group%202%20should%20only%20see%20sheet%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20have%20this%20on%20a%20sharepoint%20hosted%20excel%20workbook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20the%20Hide%20function%20which%20can%20be%20undone%20easily%2C%20as%20well%20as%20VeryHidden%20on%20VBA%20but%20this%20hides%20the%20sheet%20for%20all%20users%20rather%20than%20just%20one%20group.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072669%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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