Can anyone tell me how to add a custom property field to the header of a worksheet? In Word I can use the Insert/Field command to insert things like Client name, etc into a document - how can I do this in Excel?
View/H&F, then custom header gives me the option to insert Date, page number, time, file path, etc. However, under File/Properties/Custom, I have a field called "Client Name", do you know how to insert that field into the header?
that works a treat, as always.
I'm not that good at the code stuff, but is the custom bit in Centerfooter = Cells (1,1)?
If it is, does that mean that the content of Center footer is the content of Cell (1,1) (is that A1)? If this is the case, the code doesn't do what I needed, which is more along the lines of ThisWorkbook.CustomDocumentProperties.Item.