OK... first off, Thank you so much for your speedy response!
Second... I copied in this partial code into the VB editor on
"ThisWorkbook"... now (and I'm sorry if you feel you have to spoon feed me...
I get scared of code) Say my worksheet has a column with a header of
"Project" in column D and column E has "Assignment"... I would like it to
sort primary on column D and secondary on column E. How in the world to I do
this? I'm a good student, just one that has avoided learning any type of
programing or code for years and now it's coming back to bite me.

Thanks so much for your expertise and patience!!!

"Chip Pearson" wrote:

Open the ThisWorkbook module, and use the BeforeSave event
procedure.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
'
' your sort code here
'
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"KDG" wrote in message
...
I have a shared file that is being used by some rather
inexperienced Excel
users. This file will expand with extended use as each user
enters their
data. In order to make it easier for them to use, I'm trying to
automate some
things.

Is there a way... and I'm sure there is, I'm just not
experienced enough to
know how... that I can have my file automatically sort on a
particular column
when the user goes to save it? I'm thinking that this must be
either a macro
or VBA or whatever, but I am rather a novice in this area.