Reply to thread

Message

[QUOTE="David McRitchie, post: 3298153"]
Hi Bonnie,
You could just give them a background color to discourage them
from entering into such cells; however,  there have been posted macros for
sorting of content within protected sheets.

One way is to just     protect the userinterface

[URL]http://google.com/groups?threadm=B75A3208.13C2%25bernard.reyPasDePollupostage%40free.fr[/URL]

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  [URL]http://www.mvps.org/dmcritchie/excel/excel.htm[/URL]
Search Page:        [URL]http://www.mvps.org/dmcritchie/excel/search.htm[/URL]

protect the sheet and then go back and un-protect the cells that they can type in....that works for the cells with the formulas, but
then the cells they can type in can not be sorted.  The sort function is not available.
unprotected cells.  Can someone help?  I've searched other areas here, and all I keep finding is a reference on what I've already
done (which won't allow a sort).
[/QUOTE]

Verification