Autofilter and protected sheets

E

Edward Robson

I'v protected some of the cells on my worksheet (Excel 2000) but now
the Autofilter dropdowns won't work. Any thoughts please.
 
D

Dave Peterson

If you protect the sheet in code, you can allow this:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableAutoFilter = True
End With
End Sub

(The worksheet has to have the dropdown arrows already applied.)

It needs to be reset each time you open the workbook. (excel doesn't remember
it after closing the workbook.)

(you could use the workbook_open even under ThisWorkbook, too.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
P

Phoenix

This worked fine for me, with one worksheet or more:

Sub workbook_Open()
Sheet1.EnableAutoFilter = True
Sheet1.Protect userinterfaceonly:=True
Sheet2.EnableAutoFilter = True
Sheet2.Protect userinterfaceonly:=True
Protect Password:="pass"

End Sub


....and the same for sheet 3, sheet 4 etc.

With Workbook Open as Dave said, it will start automaticaly
when you open the workboo
 
Top