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.
Bookmarks