Thanks for the code. I'm using the VBA code of this page. Is there a way to add a sorting code after the unique values are extracted so it sorts it automatically?
I know that this is necroposting but I had the same issue following similar instructions. What I had to do was create a self signed digital certificate for my macro. (located C:\Program Files\Microsoft Office\root\Office16 for my install of Office 365.) Then I saved it. Then I opened up (alt+f11) and under Tools->Digital Signature for the macro I created I signed it with my self signed cert. Then I went to File->Options->Trust Center>Trust Center Settings>Macro Settings and selected "Notifications for digitally signed macros, all other macros disabled". Click okay. Run your macro it'll warn you about it and you select "Trust all macros from this publisher". You can always check the certificate to see if its the correct one too. Hope this helps someone!
A corporate account pwd is outdated so I get popups every other minute - your method does not work (even after restart) and get rid of the security warning (re-focus window, stop syncing, ...)
Mini Tractor price
Thanx for sharing the story
Ashok Leylend Truck