1. paste as values, then paste again as formats

2. what verion of Excel.
a. If you want links to be updated without prompt (and you say not),
then look in Tools=Options= Edit and uncheck ask to update automatic links
b. If you don't want them updated and don't want the prompt, in xl2002
and later, go to Edit=Links and click the starup prompt button. Make the
appropriate selection. Not available in xl2000 or earlier and no work
around.
c. Otherwise, Remove the links by replacing the formula with the
displayed value.

--
Regards,
Tom Ogilvy

"rn" wrote in message
...
How do I do the following using macros,

1.Paste as values without losing the format?

2.Stop all links in a workbook being updated?

Thanks.