Protecting Worksheet but allow certain actions

[Sherry]

Can someone tell me why it is that on Excel (Version 2002)
I cannot specify which actions to allow my users to do if
I protect a worksheet. It allows me to checkmark options
I want my users to be able to do, but when they try to
perform them, it tells them that the sheet is locked and
therefore read-only. I am wanting my users to be able to
sort, and also to be able to filter data, and I have
checked both options when I am in the process of
protecting the sheet. Any help on this?

 

[Ron de Bruin]

Hi

Are they also using 2002 /2003 Sherry?
If they use 97/2000 it will not work for them

 

[Sherry]

Ron,

Hi. Thanks for responding. Yes, they are using 2002 as
well. Any ideas?

 

[Ron de Bruin]

Hi Sherry

Try to turn on Autofilter before you protect the sheet

 

[Sherry]

Ron,
Thanks so much, that worked beautifully!

Sherry

 

[Guest]

I am using Excel 2003 and am having the same problem. I turned on Autofilter before protecting the sheet and it still doesn't work for me. Any other suggestions

----- Ron de Bruin wrote: ----

Hi Sherr

Try to turn on Autofilter before you protect the shee

 

[Dave Peterson]

And you checked the "allow users to use Autofilter" in the
tools|protection|protect workbook dialog?

And all your users are using xl2002 or xl2003?

 

[Dave Peterson]

This feature (granular levels of protecting a worksheet) was added in xl2002.
I'm not sure why it's not working for you, but if you're going to share with
xl2k (and before) users, you'll have to use code to get that effect.

I've lost the beginning of this thread, so here's what I'd use in the Auto_open
procedure in a General module:

Option Explicit
Sub auto_open()

Dim wks As Worksheet
Set wks = Worksheets("sheet1")

With wks
.Protect Password:="hi", userinterfaceonly:=True
.EnableAutoFilter = True
End With

End Sub

(you could use the workbook_open event under ThisWorkbook, too.)