Airborne,
I'm a little stumped as to why it wouldn't work on the IT pc's too. If all the configurations are the same, and you're using the most up to date file, that doesn't really make sense to me. Are all the same add-ins installed?
And now for something completely different... If you don't have commonly used search terms, it puts a wrinkle in that plan, but what about this...
You only have 8 textboxes in a file, right? So if you dumped the entire contents of your textbox into a cell (8 columns, 1 for each textbox), and also the file path and name (in another 2), using the workbook_beforesave event (in the tb laden files)...
You should then have a master list of all contents of all textboxes in all files with their paths. Theoretically, you should be able to search using the find method on the worksheet list, and if the term shows up in any of the columns, add the file path to an array. Once you have the array, open up each file in it.
I would think it would be way faster than opening, checking, closing, etc...
Just a thought. What do you guys think?