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