View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Murphybp2@gmail.com is offline
external usenet poster
 
Posts: 4
Default Creating a User login Log file for an Excel workbook

I would like to create a simple log file for a shared workbook I have.
Preferably I'd like the log to be on a hidden worksheet within the
workbook. All I need to capture is the userID, Date/time the workbook
was opened, and the date/time the workbook was closed. Can some one
tell me how I would go about doing this. I imagine I would have to use
some VBA to accomplish this. Thanks.