Auto Sort

Hi everyone, back again, you guys helped me a lot yesterday.

My problem this time is in regards to auto sorting a table as data is changed in another worksheet and is auto copied within the said table.

I.E. I need the Fax page (second last), the table has to auto sort based on column " C ". This is easily done using custom sort but can it be done automatically ? I want to lock the page so nobody modifies it.

I attached a copy of my work so far, using Excel 2007.

All the sheets are locked except " Player DATA " and " Fax ".

The password is " Moose ".



Here is what I found . . .

here is another post in this forum that is exactly what I need but cannot get it to work.

http://www.excelforum.com/excel-2007...o-sorting.html

and here is a copy of the code I recorded using macro recorder ( Please be patient as I'm driving blind here )

Sub AutoSort()
'
' AutoSort Macro
'

'
    ActiveWindow.SmallScroll Down:=-12
    Range("A5:C29").Select
    ActiveWorkbook.Worksheets("Fax").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Fax").Sort.SortFields.Add Key:=Range("C5:C29"), _
        SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Fax").Sort
        .SetRange Range("A5:C29")
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
End Sub

so to recapitulate, I need the Fax page to update (auto sort) when the data is changed in the " Player DATA " worksheet.