Hi Dmag

See the macro examples
http://www.rondebruin.nl/values.htm

If you want to mail the workbook I have a Add-in that can do that
and mail the file


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dmag" wrote in message ...
I have a workbook with several tabs all with formulas. When I Distribute I
like to eliminate the formulas so I copy & paste the values. It just takes a
while since I have to do it for several tabs. Any way to do this for the
workbook in one shot?