VBA Code which allows auto filter and sort in a protected sheet
I found the following code but it is for Excel 2000 and does not work for my Excel 2007.
What need to be changed?
The name of the sheet it "Matrix" but I would like to name it COA-Matrix or COA_Matrix.
thanks for help
Private Sub Workbook_Open()
Matrix.Protect Password:="123456", DrawingObjects:=True, _
contents:=True, Scenarios:=True, _
Matrix.EnableAutoFilter = True