Breaking Links with previous Spreadsheets

[columbo1977]

Good Afternoon All

I have VBA code that copies several sheets froma workbook password protects then emails the document to a specified address.

What I need now is the code to tell the new document to break the links with the old one.

Original thread here :

http://www.tek-tips.com/viewthread.cfm?qid=1475079&page=1

Hope someone can help.

Columbo1977

 

[halobender]

are you wanting this to break links with another worksheet because the data is coming up #value or #na due to missing information.. if that is the case then you have left something out of this post and your previous post. somewhere you have managed a copy paste where excel is still referencing another sheet/workbook you will need to set all copy/paste to paste values only. If this data is already presently stored while you are working with it as links to other work sheets you will need to make a copy/paste loop to change your data to values instead of the formula links.

hope this is what you were referring to and that this helps.

if you need help with the loop please explain how your data is set up

 

[SkipVought]

Hi,

I would not copy the SHEET.

Add a new workbook.

Copy the CELLS on your sheet.

Paste Special VALUES & FORMATS into the new worbook.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]