I am relatively new to VBA. would like to know how to make a script to take multiple files in a folder, search for 2 specific sheets that may or may not be hidden, and go into those sheet to click a 3rd party button in a ribbon then close it.

Thanks,

J