sort data when sheet is protected

[cidfidou]

Hi Excel Gurus,

Does anyone know what setting should I use in order to allow a user to sort data in a table when some of the cells are locked?

When I protected the sheet I ticked the option to allow user to sort data but it doesnt work...

Any help as usual would be greatly appreciated...

Cheers

 

[gorem]

I would be fascinated to know if there is a solution to this. I had a similar problem with a tool I built recently.

As far as I can tell, this is an Excel bug. Sorting manually in a table on a protected sheet does not work even if the option you mentioned is selected (which should fix the problem, one would think). You can get around this by adding a series of buttons and writing VBA associated with each one to sort the various ways users might want.

 

[cidfidou]

Thanks for Feedback Gorem. I will write a macro then