Okay, I've tried everything, I've looked everywhere and I simply can't find the answer.....

I have a random between formula in a worksheet. As expected it will randomize on recalculation, however I don't want this to do this! I need the sheet to be able to be used and have calculation run, but stop the Randomizing.... However, I need to be able to maybe on a click of a button re-randomize the list. I need to be able to do this when ever I want but i can't have it just go off on its own, I do not want to just paste the result.....

I want to Randomize on Command.