Sorting Query

[AliGeeJay]

I have a query relating to sorting in Excel that has me stumped at the moment.

I have a table with five Command Buttons in Column A. In the columns B - E is the data.

When I select Column A - E and try to sort, on Column C for example, the data sorts as expected but the Command Buttons in Column A do not move.

I have checked the Command Button properties and they are all set to Move and Size with cells.

All I can find when searching is how to sort using a Command Button, not how to sort a column that contains Command Buttons.

Any help will be gratefully received.

 

[rlv01]

I find that if you size the buttons (or the cell) so that each button fits entirely within one cell and does not overlap into any other cell, then the buttons will sort with the cell. If there is any overlap with another cell, they will not.

 

[AliGeeJay]

Thanks for the advice. It worked perfectly.