Custom sort in macro disappears
 

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

Custom sort in macro disappears
 

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?

Custom sort in macro disappears
 

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

Custom sort in macro disappears
 

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