One macro to systematically run F5 key on up to 20 other macros
I have put together a series of macros which autofilter information to create a report on different tabs within a workbook. Having 17 macros all similar it would be handy to have one macro which would systematically activate each Module in turn and therefore require just the one key combination Ctrl+Shift+(?)
Software/Hardware used:
Excel 2003
Software/Hardware used:
Excel 2003
ASKED:
February 18, 2010 2:31 AM
UPDATED:
February 25, 2010 11:10 PM
Answer Wiki:
What? No one has answered?
Go to the VBE (Alt F11).
Create a Macro called Main. Assign it to your Ctrl+Shift+(?). Here is the code:
<pre>
Sub Main()
Macro1
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
End Sub
</pre>
This assumes you've used the Macro Recorder and let it automatically name each macro. If you named the macros something else - just substitute that name for Macro#.
I hope this helps. Since you're into Excel reports, you might want to check out my blog: <a href="http://itknowledgeexchange.techtarget.com/beyond-excel/forward/">Beyond Excel</a>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
