Sorting protected cells

[gailb14]

I have a spreadsheet that is filled in by other employees. I have certain cells that I do not want to change. I have adjacent cells that change daily. I want to be able to sort all of the information.but an error comes up and says "Excel found data next to your selection, but you do not have sufficient permission to change those cells."

Is there anyway to sort data that is protected?

[VBA Noob]

See if this link helps

http://exceltips.vitalnews.com/Pages...orksheets.html

VBA Noob

[gailb14]

Thanks for the quick response but I must be doing something wrong. I chose sort in the menu like it said but when I put the protection on it would not let me select any cells. Help

[VBA Noob]

What version of excel are you using.

As the link says excel 2002 and newer allow you to specify what users can and cannot do with a protected worksheet

If you get a list like the one on this link (Step 2) you should be able to select allow sort

http://www.bettersolutions.com/excel...E028820332.htm

VBA Noob