What worksheet event will allow me to trap changes to comments?
--
Gary''s Student

There isn't one Gary.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Gary''s Student" wrote in message
...
What worksheet event will allow me to trap changes to comments?
--
Gary''s Student

Thank you Bob:

b.t.w Do you know of any technique to link comments? So changes to a master
comment will be reflected in all linked copies?
--
Gary''s Student


"Bob Phillips" wrote:

There isn't one Gary.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Gary''s Student" wrote in message
...
What worksheet event will allow me to trap changes to comments?
--
Gary''s Student

Not off the top Gary. The problem would be storing the linkages I guess as I
don't think there is an linking facility in Excel. This would need coding,
not difficult, but I can't say I have ever done it.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Gary''s Student" wrote in message
...
Thank you Bob:

b.t.w Do you know of any technique to link comments? So changes to a
master
comment will be reflected in all linked copies?
--
Gary''s Student


"Bob Phillips" wrote:

There isn't one Gary.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Gary''s Student" wrote in
message
...
What worksheet event will allow me to trap changes to comments?
--
Gary''s Student

Thanks again Bob.

I'll give the financial people a small macro to run after updating the
master comment. They will need to add a comment number in the comment text,
but I am sure its much less work than the manual search-and-update procedure
they are currently using.
--
Gary's Student


"Bob Phillips" wrote:

Not off the top Gary. The problem would be storing the linkages I guess as I
don't think there is an linking facility in Excel. This would need coding,
not difficult, but I can't say I have ever done it.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Gary''s Student" wrote in message
...
Thank you Bob:

b.t.w Do you know of any technique to link comments? So changes to a
master
comment will be reflected in all linked copies?
--
Gary''s Student


"Bob Phillips" wrote:

There isn't one Gary.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Gary''s Student" wrote in
message
...
What worksheet event will allow me to trap changes to comments?
--
Gary''s Student