Sorting data in a protected worksheet

I need help in sorting a table on a Protected worksheet. I do not know if there is a non-VBA method of doing this, or should I be using VBA.

The table is in the Range B12:D150, and is Unprotected. I have formulas in columns F to H, which is protected.

When I Protect the worksheet, I allow users to:

- Select Protected Cells
- Select Unprotected Cells
- Sort

I have added macros to buttons, which sorts the table correctly when the worksheet is not protected, but as soon as I protect the worksheet, I get an error message saying the worksheet is protected and therefore read-only, and I should unprotect the sheet first.

I would like to keep the worksheet protection, as I do not want anyone to change my formulas. I would appreciate any help in resolving this problem.

you need to include some vba code before and after to deal with the protection

Please Login or Register  to view this content.

Thank you Sean. This has helped me resolve my problem.

I have changed your code slightly:

Please Login or Register  to view this content.