View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

I believe with XL2000 you need to use:

With ActiveSheet
.Protect Password:="hello", UserInterfaceOnly:=True
.EnableAutoFilter = True
End With

With XL2003 you have the option of setting it when you
protect the sheet, or you could use:

With ActiveSheet
.Protect Password:="hello", AllowFiltering:=True
End With

---
HTH
Jason
Atlanta, GA

-----Original Message-----
Excel 2000 ... TabSheet contains "Filter" Switches ...
However, when I "Protect" TabSheet "Filter" Switches
appear to deactivate ... That said ... is there a way to
set TabSheet Protection so "Filter" Switches will still
work???

Thanks ... Kha
.