excel - Create a log to record users who open file as Read-Write -


my team has several files designed other associates record work in, not save file itself. there way create version of user log or change log records when opens file read-write or enters password file? files password protected, seems able access them that's not supposed have pw.

i can create code record username , time once macro recognizes file opening; i'm not sure how tell, if possible, when it's opened read-write or read-write password entered.

if not thisworkbook.readonly then... 

write user name text file


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -