View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default how do i lock a sort, ie no header row

hi
record a macro. Toolsmacrorecord new macro....
give the macro a name. do your sort. the macro will remember.
you can assign the macro to a toolbar icon, a sheet command button or select
from the menu i.e. toolsmacromacrosselect macrorun

regards
FSt1



"sotydor" wrote:

I want to sort by no header row, colum M, the colum N, then colum O.
I do not want to have to insert this data everytime I sort. How can I
preserve the order of this sort?