Thread: macros
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Steve Walton
 
Posts: n/a
Default macros

On Tue, 7 Mar 2006 05:40:30 -0800, Kevin B
wrote:

Create a new procedure in any of the existing modules you may have in your
work book and just list the names of the macros you wish to run, in the order
that they are to be run in.

Sub RunEmAll()

MacroName1
MacroName2
MacroName3

End Sub

Then run your new procedure to execute them all.


How do you refer to macros in a different module and or .xls file

--

Steve