Workbook tracking.
 

I'm not sure if this is a programming question of sorts, but hopefully
someone here will have had to at least think about this before.

What I'd like to do is track users opening a Workbook. I just want to know
basic info, such as username and is possible time it occured.

I could, I suppose, write a logfile to do this on WorkBook_Open and grab the
environ.user as write is somewhere. However I was hoping that rather than
having to resort to coding, Excel may offer me an inbuilt option. Sharing the
Wrokbook is no good as I need to know users who access the sheet and make no
changes too!

Any help would be great.

TIA.

Workbook tracking.
 

There is no automatic way to track a workbook's usage. You'd have
to write code in the Workbook_Open event to catch the
information.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DaveO" wrote in message
...
I'm not sure if this is a programming question of sorts, but
hopefully
someone here will have had to at least think about this before.

What I'd like to do is track users opening a Workbook. I just
want to know
basic info, such as username and is possible time it occured.

I could, I suppose, write a logfile to do this on WorkBook_Open
and grab the
environ.user as write is somewhere. However I was hoping that
rather than
having to resort to coding, Excel may offer me an inbuilt
option. Sharing the
Wrokbook is no good as I need to know users who access the
sheet and make no
changes too!

Any help would be great.

TIA.