Can I reorder rows with locked cells?

[mrgrotey]

Hi guys this is my first time on the forum and hopefully you can help me here.

I have created a simple spread sheet for my girlfriend's workplace. Is it basically a list of shop branches showing the weekly takings .etc. the last few cells in each row have some simple formulas and conditional formatted colour schemes to automatically calculate such things as percentages and totals .etc for the weekly takings of each branch.

Once the values in the main body have been entered she requires the whole list to be sorted into decending order based on column Z.

This is all simple to do with the sort command after selecting the appropriate rows. However the problem comes when the people in the different branches using this chart aren't quite as 'computer minded' as some and every now and again they keep removing the forumlas accidentally in the end cells. I can lock the formula cells and protect the sheet to stop any tinkering of the formulas but this then stops the ability to sort the rows into accending order because the rows are no longer selectable due to the locked cells.

So is there any work around for me here? I need to lock some cells but still have the capability of sorting the rows into decending order based on a particular collumn?

Is there any hope?

Thanks very much for your time.

Michael

[Richard Buttrey]

Hi,

What's the purpose of sorting and what's in column Z?

If the object is to see all similar items together then you might consider a Pivot Table which is set to sort the appropriate column in order. This would also offer you much more functionality for reviewing and dicing/slicing.

If you need to sort the list in the manner you describe then I'd be inclined to write a simple macro and attach it to a button. The first line of the macro would be
ActiveSheet.Unprotect
and the last line would be
ActiveSheet.Protect

or alternatively select the Sort option when you set protection

[y_not]

Hi Michael,

Not sure if I understand but, when you protect the sheet the option is there to "Allow all users of the worksheet to:" and one option is "Sort".

Have you tried that?

Sorry if I misunderstand

[mrgrotey]

The chart basically ranks the company branches for the amount they make in any given month so the last collums in a percentage achieved of their target and thats the column that needs to be sorted in decending order so the best shop is at the top .etc .etc.

y_not: I never really looked at that list before in the pop-up window but that would have been an option.

However Richard's suggestion of a macro that unprotects the sheet, sorts the collums and then protects it again is perfect as a simple button can do it all in one click! So simpel Im annoyed I didnt think of it!

thanks for the lightning responses!

Michael