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

[chiefcook]

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?

 

[Peter Jausovec]

Hi,

You will have to use VBA code. Check the samples here:
http://www.cpearson.com/excel/docprop.htm