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
.
|