Log for a workbook

[Farah]

Hello,

Can excel start creating a log file having information of what was done since the user opened the Workbook.

Warm Regards,
Farah

 

[Tazguy37]

What kind of information? Have you looked at using Tools, Track Changes?

 

[Farah]

hello Taz,

Oh yes, Track Changes... but don't want the changes to be shown on the sheets itself. I want something like this in a seprate sheet.

Sheets "Report 99" selected.
Copied Cell A12
Pasted in A44
Sheet "Report 98" selected
Column E Highlighted
Yellow colour filled

I mean every action that a user will take on my workbook starting from Workbook Open till the workbook close.

Is that possible.

Warm Regards,
Farah

 

[Tazguy37]

As far as I know, only the macro recorder is so literal.

Can you turn on the recorder with code? I have no idea, honestly. Probably could be done with SendKeys....

 

[Farah]

Poor thing is that even the Macro Recorder doesn't Record all the things like Alt+F11 etc.

 

[Tazguy37]

I should have asked this earlier, but, why exactly do you want to record all this? It's much easier to make it so users can't use certain functions rather than recording everything they do do.