I have a macro that includes a custom sort of column A (and all of th
info in that row) in a specific (not alphabetical) order. All of th
calculations need to have the list of names in the proper order. Th
sorting works on my computer, but when I email the spreadsheet t
another computer, the macro no longer sorts by the custom list
originally put in the macro. Any suggestions as to why it would d
this

--
backbutto
-----------------------------------------------------------------------
backbutton's Profile: http://www.excelforum.com/member.php...fo&userid=2032
View this thread: http://www.excelforum.com/showthread.php?threadid=50662

backbutton wrote:
I have a macro that includes a custom sort of column A (and all of the
info in that row) in a specific (not alphabetical) order. All of the
calculations need to have the list of names in the proper order. The
sorting works on my computer, but when I email the spreadsheet to
another computer, the macro no longer sorts by the custom list I
originally put in the macro. Any suggestions as to why it would do
this?

Where did you save the macro to? Was it in the spreadsheet you sent?

I am fairly new to macros, so I really appreciate your help. I creat
the macro, then assign it to a button. Is there more I should be doing
The macro runs great on this computer. Thanks agai

--
backbutto
-----------------------------------------------------------------------
backbutton's Profile: http://www.excelforum.com/member.php...fo&userid=2032
View this thread: http://www.excelforum.com/showthread.php?threadid=50662

JD,

I have figured it out. The custom sort lists were in a different orde
on the other computers. The macro was telling it to pick custom sor
#6, while on the other computers the correct sort was listed as #7.
went into the VBA on those computers and changed the code and it no
works.

Thanks for your interest

--
backbutto
-----------------------------------------------------------------------
backbutton's Profile: http://www.excelforum.com/member.php...fo&userid=2032
View this thread: http://www.excelforum.com/showthread.php?threadid=50662