View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan Rowan is offline
external usenet poster
 
Posts: 3
Default Protection and filters?

Pau

You can allow filtering on a protected sheet using the following code

With Worksheets("Sheet1"
.Unprotect Password:="YourPassword
If Not .AutoFilterMode The
.Range("A1").AutoFilte
End I

.EnableAutoFilter = Tru
.Protect Password:="YourPassword",
contents:=True, userinterfaceonly:=Tru
End Wit

Regard
Rowan