Absolutely. the log file can get rather large though. What I would suggest is this: Create multiple log files. (1) "Master" log file and one log file for each userid. then, in your file, create a workbook_open event and delete any existing log file with the userid, and open it new. then, create a Workbook_SheetChange event that writes the sheet name and cell values to the userid log file.
then, create a Workbook_Save event that copies the user log file to the "Master" log file. this way, if the user makes a bunch of changes, and doesn't SAVE the file, then the changes are discarded. do you need help with this? Paul ________________________________ From: lokerin <benjamin.f...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Thursday, June 18, 2009 3:40:46 PM Subject: $$Excel-Macros$$ ACCESS scurity hey all hopefully you can help me and a friend of mine. he has a DB that people keep messing with and i am trying to help make a log file fore it. i am mostly familer with excell VBA but i would not even know where to begin. is it possible to create a log file with some ones user name IP address and what part of the file they accessed? --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
