Bloody Formulas! They never work when you want them to

[alexb]

I have a work that I have created a macro to go with.

The macro cuts and pastes 1 of the sheets into a new workbook that I can email to a customer without him seeing the other sheets. However, when I email it internally (to check it works) my mate comes up with a prompt that says "this information is linked to another workbook - Do you want to update yes or no". If he clicks Yes it reverts back to the wrong priceing, customer name etc... How can I stop him haveing the prompt?

It is fine before he clicks yes...

 

[Russell Hauf]

Everywhere you have ActiveSheet.Paste, put

Selection.PasteSpecial Paste:=xlValues

(unless the person(s) you are sending this to need any of the formulas)

Hope this helps,

Russell
This message was edited by Russell Hauf on 2002-03-11 13:58