Applying tracking to workbooks which include dropdown boxes

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

Originally Posted by EefsMc

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

Could you upload an example file? (follow the instructions in the yellow banners).

Which file do you need an example of? The worksheet in question is a simple table format with filter applied. If the filter is applied, the "Track Changes" under the review tab cannot be applied and vice versa.

Originally Posted by EefsMc

Which file do you need an example of? The worksheet in question is a simple table format with filter applied. If the filter is applied, the "Track Changes" under the review tab cannot be applied and vice versa.

It's a lot more complex than just "here's the code", we would to need to see an example of what we are working with so that we can solve the problem.