Activity Log - Excel

[Rahulwork]

Hi Everyone,

I have an excel contains value and embed objects.

I Want since open, all activity should be track in excel (Edit, Add, add/delete embed docs etc)

log should be password protected on excel.

is it ppossible?

let me know for further questions

 

[sergioMabres]

Theoretical it is, using worksheet change event, like: [FONT=&quot]Private Sub[/FONT][FONT=&quot] Worksheet_Change([/FONT][FONT=&quot]ByVal[/FONT][FONT=&quot] Target [/FONT][FONT=&quot]As Range[/FONT][FONT=&quot])
But it is a lot of work to create an encrypted log file with every edit, add or delete, close to 40 hours of coding
Cheers
Sergio[/FONT]