On Sat, 31 Jan 2009 13:28:09 -0800, Secret Squirrel
wrote:

I have macros in vba behind 4 of my worksheets. How can I combine them into 1
macro and be able to just run one? Here's what I put into a module but it
doesn't seem to be working:

Sub RunAvonReports()

CopyOpenOrders
CopyBookings
CopyShipments
CopyNotInvoiced

End Sub

Those are the 4 macros I'm trying to run at once.

Try the following:


Sub RunAvonReports()
Sheet1.CopyOpenOrders
Sheet2.CopyBookings
Sheet3.CopyShipments
Sheet4.CopyNotInvoiced
End Sub

Replace Sheet1 etc with your own sheet names.

Hope this helps / Lars-Åke