Hello.
In a workbook I have 3 modules (mod1, mod2 and mod3) for 3 worksheets (Sheet1, sheet2 and sheet3).
I need a button to execute the 3 modules. I have been looking out for a solution for this. I tried a lot but unable to do it.
So, I am wondering is it possible with a module to execute more than one module.
Any help is welcome
There are Modules and there are Macros which are two different things. It sounds like you've conflated Module with Macro. You wouldn't execute a Module.
This Macro will run three other macros called Macro1, Macro2, and Macro3.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I moved the code from each module to each macro and the Macro_All run the 3 macros.
Thank you very much indeed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks