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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to password protect a cell but still be able to sort ? (https://www.excelbanter.com/excel-worksheet-functions/22727-how-password-protect-cell-but-still-able-sort.html)

GW Trainer

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

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?

Carole O

AFAIK you'll have to unprotect the sheet, sort it, then protect it again.

Carole O

"GW Trainer" wrote:

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?

All times are GMT +1. The time now is 06:10 AM.