Is it possible to create a macro recorder in code? I know Excel has its own
macro recorder. I also know that Excel has versioning tools which highlight
changes that have been made.

I want to understand how these tools actually work. Are their methods which
can be inovoked to see what the last action was in a spreadsheet?

Thanks

EM