Record when a workbook is opened, closed, saved, printed, protected and unprotected

**vew32** · 09-25-2014, 05:13 AM

Hi so I have a workbook with a sheet called 'Events'. on the sheet i have a table with the following headings:

Date Time Event ID User Workstation Comments

I want to record when the work book is opened, closed, saved, printed, protected and unprotected by a user.

So far the only two I cant do is protected and unprotected.

I want to know what users are making changes that are protected by passwords, 99% of the time its by authorised people but occasionally someone knows a password they should and makes a change that causes all kinds of issues.

The code I have so far for the the rest of the items is as follows:

(sorry for all the comments helps me keep track of what is what and why so I can cannibalise on other projects)

Please Login or Register  to view this content.

**Tsjallie** · 09-26-2014, 09:21 AM

There's no (decent) way to trap the event of protecting/unprotecting a worksheet.
However, what you can do is trapping changes in the worksheet and then check if the user is autorized to make that change in that specific cell (or range of cells).
And if not log the event.