As ALWAYS, post your code for comments. Some code created in 2007 may not
fire in 2003. I have both to test
If desired, send your wb to my address below along with a complete
explanation.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"amaries" wrote in message
...
I have a macro that I created in 2007 that I would like to make available
for
my users of 2003. I have the icon on the quickaccess toolbar. It is only
one
macro that aligns the columns, sorts based on column A (customer #),
applies
5 conditional formats that color entire row based on contents of column K
(status of customer order), then subtotals column L (order total) by
column A
(Customer #). One click and viola! Is it possible , if so how, to copy
this
macro to my users of 2003? Or do I have to create it in 2003 then copy
it?
Where can I find the macro to make available to them?