Hi,

I have a workbook that sits on the network and can be opened,
read-only, by sales staff.

I need to be able to see when the workbook is opened (read-only) by
each user (each has a different IP).

I dont want to use 'Track Changes' as I dont want to share the
workbook.

Does anybody have some VB that could either update a list or send an
email containing the IP address, date and time, on the open event of
the workbook. I suppose the 'Read-only' asspect is the biggest problem
with this.

Darren