Running Multiple Macros From Multiple Worksheets Automatically When File Is Opened

I am looking to automatically run multiple macros from multiple worksheets when the Excel file is opened. I have tried using

Please Login or Register  to view this content.

However, this only works if the user is on that specific worksheet when closing.

I have 5 worksheets (Worksheet1, Worksheet 2, etc) and on each Worksheet there are corresponding macros (Macro 1, Macro 2, etc). The macros are for that specific sheet only and I need them to run automatically when the file is opened.

Please help!

No idea what the codes are, but you would probably have to select the correct sheet in each macro.

Are they the same codes but for each sheet?

When you have something that doesn't work, it always helps to describe what "doesn't work" means. Are you getting an error message? Does the code just not do anything? I don't see that here so I will guess.

The macros in each worksheet must be declared as Public (not Private). If you have done this, then your code is simply

Please Login or Register  to view this content.

When I changed it to your suggested code. I get the other message 'Run Time Error 424. Obeject Required' when opening.

When I use

Please Login or Register  to view this content.

it does run the macro. However, it applies it to the last active sheet when it was originally closed. I need all macros to run but to the corresponding worksheet.

Thanks.

When posting code snippets, please use the code tag button (#) provided on the toolbar. Thanks.

No - I added the code tags for you - see the edit note at the foot of your post.

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

Can you help with my query?

No, sorry - I am afraid that I am not a VBA specialist.

There were problems with selects in your macros.

You can use these, they no longer have selects.

Please Login or Register  to view this content.

Workbook Module

Please Login or Register  to view this content.

You can also just combine the codes

Please Login or Register  to view this content.

Worksheet Module

Please Login or Register  to view this content.