Track Changes ( Makes "Undo/Redo" Function Unavailable - Any VBA to Re-Add it?)

Hi Guys,

I am working on a simple excel table which will be sent to various ppl for validation. Changes will be made and I need to keep a track of these. I have seen some macros that will highlight new amendments in red which is cool, but I think that the Track Changes feature is better suited to capturing and recording the changes (cell changed from X to Y for example).

The only problems I face are as follows:

- The Icon indicating that a cell has been changed = very small and dark blue. Is there a way to make this more noticeable?
- Track Changes disables Undo/Re-do. Is there any kind of VBA that can overcome this?


Thanks for your help.