Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection and filters?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection and filters?
Hi
see your answer in Excel.worksheet.functions -- Regards Frank Kabel Frankfurt, Germany Paul wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection and filters?
Many thanks Rowan.
A perfect solution. Paul -----Original Message----- Paul You can allow filtering on a protected sheet using the following code: With Worksheets("Sheet1") .Unprotect Password:="YourPassword" If Not .AutoFilterMode Then .Range("A1").AutoFilter End If .EnableAutoFilter = True .Protect Password:="YourPassword", _ contents:=True, userinterfaceonly:=True End With Regards Rowan . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto filters and worksheet protection | Excel Worksheet Functions | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Protection and Filters | Excel Worksheet Functions | |||
Worksheet protection vs filters | Excel Discussion (Misc queries) | |||
Filters on with worksheet Protection on in Sharedworkbook | Excel Programming |