Hello All,
I would be extremely grateful if you could help me solve a problem i am currently having.
I have a spreadsheet on a server network for 100+ people to see. I need to know who has visited the worksheet? is there any way i can do this?
I understand there is a way i can create a hit counter but to this i am not sure how either.
Thank you for your time and help, hopefully we can crack this problem.
Kind regards
Kevin Maguire
I use this in a workbook I like to track who's accessing:
Please Login or Register to view this content.
It writes the date, time and user ID of anyone that opens the file to a file called Log.txt in the same directory. They need to have enabled macros for it to work but this would be the case with any other solution I think.
The code needs to go on the ThisWorkbook code page of your workbook's vba project.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks