Keep Data filtering functional when protectiong Worksheet

[Phil C]

Good morning.
Is there any way to keep the data filtering function in
tact while, at the same time, protecting various selected
cells in a spreadsheet? I am using Windows 2000 and Office
Excel 2000.
Can this be done without the use of a special macro? I
tried unchecking various combinations of the Protection,
I.E. Objects,Contents,Scenarios, but I can only unlock all
the cells or the data filtering becomes unusable also.

Thanks
Phil

 

[Tom Ogilvy]

You need to set the enableAutofilter property to true and set protection to
UserInterfaceOnly:=True. The latter can only be done with a macro. The
former needs to be done each time a worksheet is opened. - So I would say
you need a special macro

Public Sub Autpen()
worksheets("sheet1").Activate
Activesheet.EnableAutofilter = True
Activesheet.Protect UserInterfaceOnly = True
End Sub

as an example.

 

[Phil C]

Thanks Tom.

I will use the macro.

-----Original Message-----
You need to set the enableAutofilter property to true and set protection to
UserInterfaceOnly:=True. The latter can only be done with a macro. The
former needs to be done each time a worksheet is opened. - So I would say
you need a special macro

Public Sub Autpen()
worksheets("sheet1").Activate
Activesheet.EnableAutofilter = True
Activesheet.Protect UserInterfaceOnly = True
End Sub

as an example.

--
Regards,
Tom Ogilvy





.