Creating a list of workbook users
Hi, I've been thinking how to do this, but I'm not quite advanced
enough to crack it yet.
I'd like to create a macro that saves the user identity (preferrably
system logon ID, but User name from Options would suffice), and date
and time of closure to a hidden sheet in each workbook every time a
workbook is closed.
I'm having trouble with people mucking up my work and I want to know
who it is! A few people need access to edit them, so there's no
blocking them off - sorry if that was your other solution.
Thanks in advance for this.
Mark.
|