ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   comment box's to linked sheet (https://www.excelbanter.com/excel-programming/433664-comment-boxs-linked-sheet.html)

coltheplumb

comment box's to linked sheet
 
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

comment box's to linked sheet
 
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


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com