If you are creating the comments manually, then there is no event that will fire
when you create the new comment.

Maybe you could use a macro to add the comment to both sheets???

coltheplumb wrote:

Hi all again ;-)
really dont know if this can be done !!
I have linked sheets in a workbook is there anyway i can get a comment box
to copy over to a linked sheet automatically as they are created ?
thanks for any help
Colin x

--

Dave Peterson