Save and reuse sorts

[SandyB]

I have a workbook that I always create the same sorts
over and over and over. Doesn't Excel have some way of
saving the criteria for a sort so you don't have to
recreate the sort every time?! (I created cool macros
with a button for each search on the toolbar, but then I
got into all kinds of security-certification-trusted-
authorization rigamarole only to find out I have to PAY
to be authorized to create macros on my own file on a
stand-alone machine!!) PLEASE tell me there's an easier
way!!

 

[Bernie Deitrick]

Sandy,

You can self-certify yourself using SELFCERT.EXE, usually found in
C:\Program Files\Microsoft Office ??\Office?

where the ?s depend on your version of Office. Available from Office 2000
onward.

Save your macros in Personal.xls, and they will always be available.

HTH,
Bernie
MS Excel MVP