Question about sorting in protected worksheet

[Guest]

I have created a spreadsheet to be used by others in which they will input
their monthly data. So many of you have helped me put this thing together--I
am extremely grateful to you all. My hopefully last question is regarding
protection. I have protected all of the worksheets, as the last time we did
this sort of spreadsheet, novice users ended up deleting and changing all of
the formulas and links. However, I realize that you cannot use the 'sort'
function while the worksheet is protected. They will need to sort their
data. Is there a way to protect a worksheet while also keeping the sort
function?

Thanks for any insight!

 

[Cesar Zapata]

If you are using excel 2003 and may be xp... when you protect you have
the option to allow sorting. If you have lesser versions then I think
you gonna have to go VBA.

 

[Guest]

I am using Excel 2000, so do you have any idea on how I can program this in?

 

[Gord Dibben]

Cesar

Just a point here..

You can only sort on areas that have been unlocked prior to protetimg the
worksheet.

2002 and 2003.


Gord Dibben Excel MVP

 

[Gord Dibben]

SJC

Sub sortprotected()
ActiveSheet.Unprotect Password:="justme"

'your sort code which you get from the macro recorder

ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Note: for users not to have access to the password, you must protect the VBA
Project, which could be cracked by a determined user.


Gord Dibben Excel MVP

 

[Guest]

Yes, that will do it--thank you so much!!

SJC

Sub sortprotected()
ActiveSheet.Unprotect Password:="justme"

'your sort code which you get from the macro recorder

ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Note: for users not to have access to the password, you must protect the VBA
Project, which could be cracked by a determined user.


Gord Dibben Excel MVP

 

[Gord Dibben]

Thanks for the feedback.

Gord

Yes, that will do it--thank you so much!!