Thread
:
link cell format
View Single Post
#
1
Posted to microsoft.public.excel.programming
Dave Peterson[_3_]
external usenet poster
Posts: 2,824
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
Reply With Quote
Dave Peterson[_3_]
View Public Profile
Find all posts by Dave Peterson[_3_]