View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Newbie Newbie is offline
external usenet poster
 
Posts: 3
Default linked workbooks - how to move color as well as data?

We've got two excel workbooks. Workbook A is the master. Workbook B
has cells that point to cells in workbook A. So, when data changes in
A, the values change in B. So far so good.

Depending on the data in workbook A, the cells in that workbook may
change color. Workbook B gets the data, but not the color of the cell
containing the data. Is there any modification to the link that would
also pull over the cell color?

If not, is there an event that's fired when the data (from a link)
changes? it doesn't seem to fire the sheet changed event...