Button/Script to create a new workbook from a current one.
 

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.


--
downer
------------------------------------------------------------------------
downer's Profile: http://www.excelforum.com/member.php...o&userid=31686
View this thread: http://www.excelforum.com/showthread...hreadid=513831