I'm in the process of creating a workbook for work. I need to have a button on the spreadsheet that, when pressed, will create a new workbook from the current one but will just display values and not formulas.

These files will be sent to end-users, and it is very important that they don't get their hands on the original worksheet WITH the formulas.