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.