Macros Not Running in Correct Workbook

[bryanmarks]

Hi! I have six reports that need to be created either daily or weekly. Rather than manually opening each workbook separately to run the macros and create the reports, I'd like to create a single workbook (a master macros workbook) with six form buttons, one to open and run the macros for each separate report.

However, the problem I'm encountering is that instead of the macros running within the workbooks where they reside, they are trying to run within the master macros workbook. This is obviously not producing the desired results and the macros are crashing. Also, the macros within the workbooks are running immediately on opening, even without explicit code to tell them to do so. I have seen somewhere that this is a normal function when an .xlsm workbook is opened like this, however.

Can anyone help me understand how to prevent this from happening and for the macros to run within their own workbook? Here is the very minimal code I have so far for just one form button:

Please Login or Register  to view this content.

Thanks!

Bryan

[xladept]

Perhaps if you move this to the Workbook_Open event??

Please Login or Register  to view this content.

[bryanmarks]

Thanks for your reply, XLAdept. Sorry it took so long to get back to you. Unfortunately, that code didn't seem to help, but perhaps it's because I'm not familiar with the Private Sub. I'll have to look into that when I have time.

[xladept]

That code would go in the "ThisWorkbook" module.

[bryanmarks]

Yes, I found that out after doing some searching on the internet, and placed your code there. Unfortunately, there was no change to the macros' performance I'm still getting the same error.