-
I have it in my Personal macro workbook. When you run it it will bring up a dialogue box to let you pick the folder where the files you need to do the work on are.
Or you can just save it in any random workbook and run it from there. These instructions should be OK if you're not familiar with running macros https://searchengineland.com/how-to-use-macros-you-find-online-in-6-easy-steps-137786
I've used a macro to do it before. There are probably specific add-ins or programmes that do it but then I'd have had to get IT to install it. This should remove all metadata from files in a folder.