Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1406450%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406450%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20we%20have%20a%20macro%20enabled%20protected%20Excel%20workbook%20with%20multiple%20worksheets%20and%20at%20the%20same%20time%20multiple%20users%20can%20view%20and%20edit%20only%20specific%20worksheets%20that%20they%20have%20a%20password%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1406450%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406498%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406498%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F674668%22%20target%3D%22_blank%22%3E%40HenryBinan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorksheets%20have%203%20state.%20Visible%2C%20Hidden%20and%20Very%20Hidden.%20Very%20Hidden%20sheets%20do%20not%20appear%20on%20%22Hide%2FShow%20Sheets%20List%22.%20So%20basically%20what%20you%20can%20do%20is%20create%20very%20hidden%20sheets.%20And%20a%20workbook%20open%20event%20to%20check%20the%20user.%20According%20to%20the%20user%20clearances%20show%20very%20hidden%20sheets.%20And%20again%20add%20a%20workbook%20close%20event%20to%20change%20the%20sheet%20visiblity%20property%20to%20very%20hidden%20so%20that%20the%20next%20user%20would%20not%20see%20them.%3C%2FP%3E%3CP%3EHowever%20there%20are%20some%20flaws.%20The%20VBA%20passwords%20are%20very%20easy%20to%20crack.%20Whenever%20the%20user%20has%20access%20the%20VBA%20code%20any%20precaution%20you%20take%20would%20be%20absolute.%20And%20sharing%20this%20workbook%20and%20let%20it%20open%20by%20several%20users%20at%20the%20same%20time%20can%20cause%20problems%20(I%20haven't%20tried%20this%20before).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Can we have a macro enabled protected Excel workbook with multiple worksheets and at the same time multiple users can view and edit only specific worksheets that they have a password?

1 Reply
Highlighted

@HenryBinan 

Worksheets have 3 state. Visible, Hidden and Very Hidden. Very Hidden sheets do not appear on "Hide/Show Sheets List". So basically what you can do is create very hidden sheets. And a workbook open event to check the user. According to the user clearances show very hidden sheets. And again add a workbook close event to change the sheet visiblity property to very hidden so that the next user would not see them.

However there are some flaws. The VBA passwords are very easy to crack. Whenever the user has access the VBA code any precaution you take would be absolute. And sharing this workbook and let it open by several users at the same time can cause problems (I haven't tried this before).