Activity Log - Excel

Rahulwork

Active Member
Joined
Jun 9, 2013
Messages
284
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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

sergioMabres

Well-known Member
Joined
Feb 24, 2013
Messages
946
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]
 

Watch MrExcel Video

Forum statistics

Threads
1,108,948
Messages
5,525,809
Members
409,664
Latest member
Sonymacd

This Week's Hot Topics

Top