I have an application that is a template. From the template, several files are created. A separate add-in provides the bulk of the programming for the template and each file created from the template.
I frequently need to update the add-in and distribute it to my clients. Each time some change is made to the client-created files even if it's just stamping the new add-in version number and date on a very hidden sheet.
The template (and files created from the template) have a Workbook_Open procedure that runs codes from the add-in, including any updating chores.
If a user opens a file and then goes back and opens another file, the updating code is run on each of the files (both the first and second file).
My problem occurs when the user multi-selects files to open. All the files seem to open first, and then the Workbook_Open for each file is triggered; however, since the add-in assumes the activeworkbook, then the last file opened is the only one that gets updated.
Is there anyway through VBA to force the files to be opened consecutively instead of concurrently so that the Workbook_Open code (and associated code) is run before the next file is opened?