Saving a worksheet with links

[sungen99]

I have a workbook with many different worksheets in them. Each workshee
is a different trader and contains their trades for the day. I hav
created (with your help) a macro that will save the separate worsheet
to files and then email them to the individual traders. My problem i
that once they receive the email the sheet is looking for data from th
main sheet. Is it possible to take a “copy” of the worksheet and not th
actually formulas that give the data? If not how do you do this

 

[Ron de Bruin]

Hi

For example
http://www.rondebruin.nl/mail/folder1/mail5.htm

You can read this on the Tips page

Below one of this lines in the example subs (if you copy one Sheet)
Sh.copy
Activesheet.copy

Cells.Copy
Cells.PasteSpecial xlPasteValues
Cells(1).Select
Application.CutCopyMode = False


If you copy more sheets in the newly created workbook then use this after the copy line.

Worksheets.Select
Cells.Copy
Cells.PasteSpecial xlPasteValues
Cells(1).Select
Worksheets(1).Select
Application.CutCopyMode = False