A1 - write a new macro called "SuperMacro"

Sub SuperMacro()
call Macro1
call Macro2
call Macro3
'etc
End Sub

A2 - save your file as an add-in. Post it on the network and let people
download it themselves. You will want to check it very thoroughly first.

--
Allllen


"Brad" wrote:

This is a two part question. I have created several macros to run on a
spreadsheet.
Q1 - how do I combine all these seperate macros to run sequentially together
at the press of a customized toolbar button. ( I know how to create the
button).

Q2 - once I combine the macros into a Run all type button how do I share
this (or these) macros across my department?