Protection and filters?

[Paul]

Using XL 2000

I have posted in worksheet functions aswell because i'm
open to solutions.

I have a workbook containing 3 worksheets.
I need a to prevent users from editing Worksheet1 but
allow the filter functionality.

Any ideas?

Thanks, Paul

 

[Rowan]

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

 

[Frank Kabel]

Hi
see your answer in Excel.worksheet.functions

 

[Paul]

Many thanks Rowan.
A perfect solution.

Paul