Button to Remove all formulas but keep data

I have a heavily protected workbook that I give to others to use. Once they have filled in the data collected they return the workbook to me.

I would like to add a password protected button so i can remove all formulas and give them the workbook back with only the data - Included the calculated results based on the data input

The idea is that there is a button that requires a password (Say "Password") if the password is entered correctly it will pop up saying "remove all formulas" Yes/No options.

If Yes is selected then all formulas will be removed from the workbook but the data will remain
If No is selected then the pop up will close and no action is required
If the password is entered incorrectly there will be a pop up saying "Incorrect Password" and then the pop up will close.

I just cant get this to work and i've tried a few things. It seems this is beyond me and i'm hoping someone can help.

Thanks

**EDIT**

It's important to add that the sheets within the workbook are all protected.

I'm thinking something along these lines:

Please Login or Register  to view this content.

WBD

Yes I think that would help. Is the password they enter the same as the one to unlock the sheets?

WBD

Password is ### for everything.

Side not: This is my version, the one I hand out is controlled by a "licence Key" which is just an expiry date and a password but besides that the workbooks are the same

OK. Try this:

Please Login or Register  to view this content.

WBD