Running a Macro to run macros across different sheets

I'm having difficulty with a master macro of sorts. When I step into it and go through it step by step, it works perfectly. But when running it on its own, it just stops after the first bit.

The purpose of the macro - I have 6 different workbooks that have 1 to 16 tabs within them. Each tab corresponds to its own macro. In the workbook I have created a master macro to run all the macros within the workbook. I have been able to get these to work without issue.

Now, I want to create my Master macro that will open each workbook and run the macro to run all the macros within. It appears to open the file asked for and then stalls. It doesn't run the macro at all. I have tried Call, Application.Run, and just about everything I've been able to find through Google. I am hoping to get the macros within the workbooks to run from the Master macro that's within my personal workbook.

Any help would be appreciated. I'm not amazing at this but I'm generally able to piecemeal between different tutorials and the record macro to get something that works for me. Thank you.

---

Master Macro within my personal workbook:

Please Login or Register  to view this content.

---

DailyInventory Macro that is within the first workbook being called in the one ring macro:

Please Login or Register  to view this content.

Hi, welcome to the form
take a look this post https://www.excelforum.com/excel-pro...k-macro-2.html
This person has a master file from which the process is done.
The attached files tell the whole story, I'm sure that by editing it to your needs you will accomplish the same.

Thank you for the welcome! And thank you for the direction. It actually allowed me to adjust my workflow and also do a button to run. And it looks like I have it working for the first three workbooks but then it just dies afterwards. I don't understand why and if you can explain why as well as assist to get it to work, I'd appreciate it. I would like to understand why it's working as well as get it to work, please.

Please Login or Register  to view this content.

thank you for the code tags

I cannot test but this would be a better way for your code to work

Please Login or Register  to view this content.

I noticed you only closed and saved the first workbook, the others may prompt to save if you want to save these too just add TRUE behind the tempWb.Close