Sorting "locked" and "protected" table

[ESFjsmith]

Helllo all,
New here, looks like a very informative forum. Here is my question:

I have excel 2007 and a table with locked cells and a protected sheet. Because the cells are locked, the sort commands do not work. I have tried checking the box to sort when I protect the sheet, but it still does not work.

If I leave the cells of the table unlocked and DO NOT ALLOW to select the unlocked cells, it works, but I also have some cells that still need to be selectable when the sheet is protected.

Any ideas?

Thank you
Jim

 

[Andrew Poulsom]

Welcome to MrExcel.

To enable sorting on a protected worksheet all the cells in the sort range must be unlocked. The only alternative is VBA code that unprotects, sorts and reprotects.

 

[ESFjsmith]

Welcome to MrExcel.

To enable sorting on a protected worksheet all the cells in the sort range must be unlocked. The only alternative is VBA code that unprotects, sorts and reprotects.

Thanks for replying so quickly. I was trying to avoid another macro and use the table options for sorting, but it sounds like that is my only option.

Thanks again.