Sort while protected

[Gerry]

Hi all, I have a very large worksheet that I don't want
people changing the contents of, but I do want them to be
able to sort. Currently when I password protect the
contents, objects and scenarios the sort command is greyed
out.

How do I allow folks to sort without being able to change
the contents?

Thanks for the help.

 

[Frank Kabel]

Hi
which Excel version are you using. I think starting in
Excel 2002 you can check an option to allow sorting in the
sheet protection dialog

 

[Gerry]

Sorry I should have said I am running Excel 97. My mistake.

 

[Frank Kabel]

Hi
then I think you're out of luck. You could create a macro
as a workaound which will unprotect the sheet do the
sorting and protect the sheet again (simply record a macro
while doing this manually)

 

[Gerry]

Hi Frank, that's what I thought too but a friend said to
just make the file read-only. This will allow the user to
sort and change anything he/she wants but they cannot
overwrite the file unless they give it a different name.

Thanks for the help.

 

[Frank Kabel]

Hi
yes this is also a solution

-----Original Message-----

Hi Frank, that's what I thought too but a friend said to
just make the file read-only. This will allow the user to
sort and change anything he/she wants but they cannot
overwrite the file unless they give it a different name.

Thanks for the help.

.