My workbook consists of two worksheets, several columns are governed by a
formulas referencing both data columns in one, the other, or both worksheets.
Some of these columns require various sorts after the data has been entered,
something done on a daily basis.

Now, I would prefer to protect those cells that contain formulas and show
function results, but then the user cannot perform a sort when they want to.
If I leave the column unlocked so the user can right-click a column to sort
the function formula might inadvertently be over written.

So, the question: Can I either: protect only the function formula in a cell
but leave the value free to be accessed, or, since the user is not macro
savy, embed a button into a cell that will have the necessary macro assigned
to it, several would be required per sheet. And is creating a button in a
cell for the macros even possible?

I've tried Excel MS Help, and read through previous asked questions here on
the board, but haven't found an answer yet that makes sense to me.