[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

VBA Code which allows auto filter and sort in a protected sheet

Hi Experts,
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, _
        userinterfaceonly:=True
    Matrix.EnableAutoFilter = True
End Sub
0
Petersburg1
Asked:
Petersburg1
1 Solution
 
Chris BottomleyCommented:
Assuming you have renamed then try

Chris
Private Sub Workbook_Open()
    Sheets("COA-Matrix").Protect Password:="123456", DrawingObjects:=True, _
        contents:=True, Scenarios:=True, _
        userinterfaceonly:=True
    Sheets("COA-Matrix")EnableAutoFilter = True
End Sub

Open in new window

0
 
Petersburg1Author Commented:
thanks
0

Featured Post

Take Control of Web Hosting For Your Clients

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now