Hi All,

This is a wordy one so I apologize in advance.

I have a shared workbook that requires dropdown selections to be applied to a number of columns and a tracking system needs to be applied so we can see what changes have been made. I know these can both be done on Excel 2016 relatively easily, but applying the data validation for the dropdown selections prevents the use of the inbuilt "Track Changes" (on the review tab) and vice versa.

Has anyone found a way around this? I'm assuming that a script of description could be used to overwrite this, or to imitate the track changes after the data validation has been implemented, but I'll happy admit that my experience with coding in VBA and beyond is limited to small edits rather than fresh scripts.

Any help at all would be appreciated!

Thanks,
Eefs