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
As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.