Paste Values in multiple sheets

[Dmag]

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?

 

[Ron de Bruin]

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

 

[M Kan]

You could also select multiple sheets, CTRL-A to select all, CTRL-C to copy,
then ALT, E,S,V to paste special values to overwrite all of your formulas.
Just be sure to save the file under a different name.

 

[Dmag]

perfect, thanks! worked like a charm

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