sort protected workbook

Good afternoon jokkebal

To be honest, you're half-way there.

You have just one macro linked to the sort button that unprotects the data, performs the sort, then re-protects the sheet again, all in one movement.

Can't really take it any further than that without seeing the file, but the kind of task is the sort of thing that the macro recorder was invented for. Try it yourself and see how you go. If you get stuck, post back with your file.

HTH

DominicB



Attaching a file :
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitise the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi jokkebal

The sorting can still be automated.
If the user wants to sort on column Z, they would set, say, Z5 as the active cell and click on the sort button.

As stated above, to take this further we really need to see how your data is set out.

HTH

DominicB