Auto Color Change in Excel

All,
I am using Office XP. I have an excel workbook with 2 worksheets. One is called "DataEntry" and the other is called "Invoice". I have a column on both with the heading title of "Name Last, First".

On the Invoice worksheet I have the following formula for the cells: =DataEntry!A5. This would take the value from the DataEntry worksheet and place it in the Invoice worksheet, therefore it is linked.

That is working fine, but if I change the text color in the DataEntry worksheet, it doesn't change the text color in the Invoice worksheet.

How can I correct this?

Someone else responded too me with the following, but he was using Office 2000 and it works for him but not for me, because I am using Office XP. I think that might be the reason. Here are the instructions he gave me:

Steps:

1) In your DataEntry sheet, assign the following range name to the input cell: inp1

2) In your Invoice sheet, assign the following range name to the corresponding (linked) cell: inv1

One method of assigning a range name:
a) Highlight the cell (or range of cells)
b) Hold down <Control> and hit <F3>
c) Type the name
d) Hit <Enter>

3) Enter the following "Worksheet_Activate" event for your Invoice sheet.

Private Sub Worksheet_Activate()
[inv1].Font.ColorIndex = [inp1].Font.ColorIndex
End Sub

In case you're not familiar with VBA, here are further steps...

3a) To enter the VBA Editor, hold down <Alt> and hit <F11>

3b) If your sheets are not shown on the left, use the VBA menu - choose: View - Project Explorer.

3c) Under "Microsoft Excel Objects", click on the "Invoice" sheet.

3d) On the right side of the screen, copy and paste the above routine from here in Tek-Tips to this location in the VBA Editor.

I hope someone can help me with this problem.

Thanks in advance.

GOD is GOOD all the time!!!

why don't you just create the sheet using the format you want, and then make a custom style using format->style and use it on your second sheet?

I don't know why it doesn't work in office xp!But if u have MS's support number,U can be given some help by asking MS office produce supporter!Good Luck to U!Or U think aother way to do it!.

The problem was in the security settings. It was set to High and it had to be set to Medium.

That fixed the problem.

Thx for jbento's answer!