EXCEL password protected document... anyway of telling if someone has viewed?

%3CLINGO-SUB%20id%3D%22lingo-sub-1431580%22%20slang%3D%22en-US%22%3EEXCEL%20password%20protected%20document...%20anyway%20of%20telling%20if%20someone%20has%20viewed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431580%22%20slang%3D%22en-US%22%3E%3CP%3ERegarding%20EXCEL%20password%20protected%20documents%2C%20is%20there%20anyway%20of%20identifying%20if%20someone%20has%20viewed%20a%20EXCEL%20password%20protected%20document%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1431580%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1432065%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20password%20protected%20document...%20anyway%20of%20telling%20if%20someone%20has%20viewed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1432065%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685721%22%20target%3D%22_blank%22%3E%40Mishelli%3C%2FA%3E%26nbsp%3B%20there%20is%20nothing%20already%20built%20into%20Excel.%26nbsp%3B%20So%20if%20this%20is%20in%20hindsight%20(you%20want%20to%20know%20if%20someone%20already%20looked%20at%20a%20file)%20you%20are%20out%20of%20luck.%26nbsp%3B%20For%20future%20access%20monitoring%20you%20can%20create%20a%20macro%20to%20do%20that%20by%20having%20everything%20hidden%20and%20they%20have%20to%20supply%20a%20username%20and%20password%20or%20maybe%20just%20use%20the%20Microsoft%20credentials%20and%20then%20make%20everything%20visible%20except%20maybe%20the%20sheet%20that%20your%20macro%20is%20recording%20that%20info.%26nbsp%3B%20Of%20course%20they%20have%20to%20enable%20macros%20and%20you%20would%20have%20to%20make%20sure%20you%20can%20save%20the%20workbook%20before%20you%20show%20it.%26nbsp%3B%20You%20would%20also%20want%20to%20prevent%20them%20from%20making%20copies%20somewhere%20else%20since%20then%20the%20sheet%20may%20record%20it%20but%20you%20would%20still%20not%20know%20it.%26nbsp%3B%20That%20all%20said%20there%20are%20File%20System%20utilities%20that%20can%20control%20and%20monitor%20access%20better.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Regarding EXCEL password protected documents, is there anyway of identifying if someone has viewed a EXCEL password protected document?

1 Reply
Highlighted

@Mishelli  there is nothing already built into Excel.  So if this is in hindsight (you want to know if someone already looked at a file) you are out of luck.  For future access monitoring you can create a macro to do that by having everything hidden and they have to supply a username and password or maybe just use the Microsoft credentials and then make everything visible except maybe the sheet that your macro is recording that info.  Of course they have to enable macros and you would have to make sure you can save the workbook before you show it.  You would also want to prevent them from making copies somewhere else since then the sheet may record it but you would still not know it.  That all said there are File System utilities that can control and monitor access better.