How do you use EXCEL formula in properties of file (cell content)
 

I have an EXCEL template. I would like the "Subject" in the properties
information to automatically pick up the cell contents from the worksheet. I
have named the cell as a range. Is it possible to use a fromula to select
this information automatically?

How do you use EXCEL formula in properties of file (cell content)
 

Hi,

You will have to use VBA code. Check the samples he
http://www.cpearson.com/excel/docprop.htm
--
Lep pozdrav,
Peter Jaušovec
http://blog.jausovec.net
http://office.jausovec.net


"chiefcook" wrote:

I have an EXCEL template. I would like the "Subject" in the properties
information to automatically pick up the cell contents from the worksheet. I
have named the cell as a range. Is it possible to use a fromula to select
this information automatically?