View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Getting comment boxes to display in linked sheet.

Not without running a macro that copies them to the sheet.

--
Regards,
Tom Ogilvy


Nabil wrote in message
...
I have an application that uses an Excel sheet running in
the background which is constantly updating external data
into its cells and into some of these cells comment boxes.
The second sheet is the user sheet and is linked to this
first one. It correctly updates its cells to display the
external data being updated by the first sheet, but fails
to display the comment boxes from the original sheet.
Is there a way to make the comment boxes (and their data)
from the sheet of origin display in the linked sheet?