C
Chris_Flowers
Hi all
I have two workbooks, for this example lets call them Book1 and Book2.
Book1 contains two sheets whilst Book2 contains one.
In Book1, sheet two contains everything thats on the only sheet in
Book2 - the sheet is linked so that any changes made to the only sheet
in Book2 are made to sheet two in Book1. Book1 is available only to me
and Book2 is available to everyone.
The linking is not a problem and works fine. What I want to happen is
any changes made to Book2 (public) I want them to show up in Book1
(private) as a different colour or highlighted, until I take the
necessary action required and remove the font colour of highlighting.
Is this possible? If so, how!?
Many thanks.
Chris.
I have two workbooks, for this example lets call them Book1 and Book2.
Book1 contains two sheets whilst Book2 contains one.
In Book1, sheet two contains everything thats on the only sheet in
Book2 - the sheet is linked so that any changes made to the only sheet
in Book2 are made to sheet two in Book1. Book1 is available only to me
and Book2 is available to everyone.
The linking is not a problem and works fine. What I want to happen is
any changes made to Book2 (public) I want them to show up in Book1
(private) as a different colour or highlighted, until I take the
necessary action required and remove the font colour of highlighting.
Is this possible? If so, how!?
Many thanks.
Chris.