View Single Post
  #2   Report Post  
Peter Jausovec
 
Posts: n/a
Default 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?