how to get links to reflect format changes?

J

Jack

Re Excel 97 --

I have an Excel file with two sheets, and the data on the 2nd sheet is
linked to the 1st. However, if I do a "strike-thru" or change a font color
on the 1st sheet, that change does not appear on the 2nd. Is there a way to
do something with the link to make it happen?

Jack
 
J

J.E. McGimpsey

Not with the link (which references values), but you can use an
event macro to copy the format. one way:

Say Sheet1, cell A1 contains

=Sheet2!J10

Then put this in the worksheet code module (right-click on the
worksheet tab, choose View Code, paste the code in the window that
opens, then click the XL icon on the toolbar to return to XL)


Private Sub Worksheet_Activate()
Worksheets("Sheet2").Range("J10").Copy
Range("A1").PasteSpecial xlPasteFormats
Application.CutCopyMode = False
End Sub
 
Top