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
Post a Comment