how to get links to reflect format changes?

  • Thread starter Thread starter Jack
  • Start date Start date
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
 
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
 
Back
Top