macro for auto filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro for a form button on a sheet. It runs an auto filter, and works fine until i protect the sheet. Then it will not work. Will auto filter not work on a protected sheet?... I have changed the security settings to allow auto filter in the protection tab.
 
Bris,

You need to protect the sheet via code and enable AutoFilter.
The enable Autofilter will not stay when the workbook is closed
and reopened so you'll have to insure that the code runs whenever
the workbook opens.

Here's some sample code (modify to suit):

Sub Auto_Open()
With Worksheets("Sheet1")
..Protect Password:="pass", userinterfaceonly:=True
..EnableAutoFilter = True
End With

End Sub

John

Bris said:
I have a macro for a form button on a sheet. It runs an auto filter, and
Click to expand...
works fine until i protect the sheet. Then it will not work. Will auto
filter not work on a protected sheet?... I have changed the security
settings to allow auto filter in the protection tab.
 
Back
Top