You can't link the cell comments to another sheet. Perhaps you could
enter the comments as text in a cell, then link those cells to the other
sheet.

Wayne H wrote:
Is there any way programmatically to link cell comments
into a higher level spreadsheet? I have 8 individual
spreadsheets tracking projects. There is a column in each
to record status (red, yellow, green), and then we have
been using the comments feature to record explanations of
the status. But when I paste link into my manager's
spreadsheet all the comments get lost. Is there a way to
accomplish what I want to?

Wayne


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html