Excel VeryHidden worksheets and Access with Google Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1437688%22%20slang%3D%22en-US%22%3EExcel%20VeryHidden%20worksheets%20and%20Access%20with%20Google%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1437688%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20developed%20an%20Excel%20workbook%20with%20multiple%20worksheets.%26nbsp%3B%20Many%20of%20the%20sheets%20are%20protected%20and%20VERYHIDDEN%20from%20the%20general%20user.%26nbsp%3B%20These%20sheets%20use%20data%20for%20lookup%20commands%20in%20the%20main%20visible%20worksheets.%26nbsp%3B%20If%20a%20user%20opens%20the%20workbook%2C%20these%20VERYHIDDEN%20worksheets%20are%20not%20visible%20or%20accessible.%26nbsp%3B%20However%2C%20if%20a%20user%20access%20the%20workbook%20with%20Google%20Sheets%20all%20of%20the%20VERYHIDDEN%20worksheets%20are%20accessible%20and%20visible%20if%20the%20user%20selects%20that%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20protection%20that%20can%20be%20established%20to%20prevent%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emlw734%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1437688%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have developed an Excel workbook with multiple worksheets.  Many of the sheets are protected and VERYHIDDEN from the general user.  These sheets use data for lookup commands in the main visible worksheets.  If a user opens the workbook, these VERYHIDDEN worksheets are not visible or accessible.  However, if a user access the workbook with Google Sheets all of the VERYHIDDEN worksheets are accessible and visible if the user selects that sheet.

 

Is there any protection that can be established to prevent this

 

mlw734

0 Replies