Tips and tricks

16 January 2009

Excel VBA – tracking who has opened a workbook

Problem:

How can I keep a record of who has opened my workbook?

Solution:

Create a tracking macro and attach it to the Open event of a workbook.

If you want to track who has saved it, attach the same code to the Before Save event.

Posted by Maggie Hill