View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default link cell format

Not via formulas (linked cells).

You'd have to use some kind of macro that retreives the formatting from that
other workbook.

Another option might be to use format|conditional formatting. Maybe that'll be
enough.

wrote:

Hi,
In my program I generate an excel workbook with cells
linked to a "master" workbook using a simple formula
indicating the file name and cell. When I write something
in the master workbook, it works perfectly writing the
same contents to the linked workbook. However, if I
decide to make the text in the cell of the master workbook
bold, for example, this is not reflected in the linked
workbook. Is there anyway to link a cell, so that format
changes as well as value changes are reflected? Thanks a
lot in advance.

Joe.


--

Dave Peterson