Sort while protected

  • Thread starter Thread starter Gerry
  • Start date Start date
G

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

.
Click to expand...
 
Back
Top