Excel 2003 Sheet Ptotection with Overrides to sort

T

Techtrainer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Override protected sheet message? 4
Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting whole Protected 2003 REDUX 0
Sort Issue Excel 2003 1
Sorting while protected - this question may not have been covered. 1
using autofilter and sort, while sheet is protected 0
How to - sort a protected sheet? 0
Excel suddenly crippled by Just-In-Time Debugging 2

Top