tried finding this here but havne't been able to - I have several spreadsheets where I've created macros to sort them, as they have so many various columns that I might want to sort for different reasons on different columns.

So, I recorded the sorting macros - that's easy. Saved them to the "Personal.XLSB" rather than in the individual spreadsheets since it's used so very often. But here's the question - how on earth do I define the text in a specific cell/field as the macro? I've read several different ways using VBA and not one has worked. So, any suggestions?

Here's a screen shot, to the top right are the two fields, as an example, that I might want to sort by. Each one has a separate macro already recorded, and I used to know (a 100 years ago or so) how to assign a macro to a specific cell, but now I can't figure it out.

Again, Win 7 Pro 64 bit, Excel 2007

Screenshot:
excelsort.jpg

So, very simple, but I can't seem to figure it out!