Sub Macro1()
s = ActiveWorkbook.BuiltinDocumentProperties.Item(5).V alue
ActiveSheet.PageSetup.CenterHeader = s
End Sub
--
Gary''s Student - gsnu2007k


"Forum freak (at work)" wrote:

Hi

I use the Comments section in Summary of File Properties quite a lot and
would like to link the contents into the file footer.

I managed this when using Microsoft Word by inserting the field code
{COMMENTS} into the footer then creating a macro to update it on file
closure. Sadly I have not been able to do this with Excel.

I can reference a cell in the footer but cant seem to link the comments
section to a cell - can anyone help?

Regards
Kenny W
XP Pro and Office 2003