LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy/ move selected data from workbooks to seperate worksheets or workbooks Positive Excel Worksheet Functions 1 August 30th 07 04:54 PM
How can I move multiple linked workbooks between computers TAG Excel Discussion (Misc queries) 2 November 6th 05 01:33 AM
How do you move names and data between large Excel 2003 workbooks? shore Excel Worksheet Functions 1 September 22nd 05 12:35 PM
Preserving data integrity in linked workbooks KG Excel Discussion (Misc queries) 1 February 18th 05 12:45 AM
Controlling Linked Data to Workbooks Myrna Excel Worksheet Functions 0 November 16th 04 10:47 PM


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"