Excel 2003 Sheet Ptotection with Overrides to sort
In Excel 2003 - I have a list of data, with one column listing division and
another listing department. All cells are locked. I am turning on the sheet
protection-but putting in a check mark to allow sorting to be done and to
allow the use of the autofilter. However, once the protection is on, Excel
disallows me from doing either.
Can anyone shed light on what i am doing wrong.
Thanks
Bill V
|