How to password protect a cell but still be able to sort ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am password protecting a range of cells in Excel 2000. When I do that, I
am not able to Sort the worksheet nor am I able to insert new rows or columns.

Am I doing something wrong or is that by design?
 
AFAIK you'll have to unprotect the sheet, sort it, then protect it again.

Carole O
 
You must log in or register to reply here.

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

Excel Protection 2
Are password protected WiFi networks secure? 3
How do you insert & delete rows in a protected worksheet? 1
I can still select & manipulate locked & protected cells in '07 1
allow a user to edit ranges in a protected worksheet 3
Sorting a protected set of cells 3
Grouping on protected worksheets 4
Insert/ delete row in protected worksheet 7

Back
Top