Protecting Worksheet but allow certain actions

S

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?
 
R

Ron de Bruin

Hi

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

Lisa Workman

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
 
D

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?
 
D

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.)
 
Top