Is there macro to automate footer updates in Excel?

[Georgianne]

Is there a way to link a cell in Excell to a footer reference? Someone I work
with needs to have the power to change the date on the footer and affect the
entire workbook by just changing the date in one cell reference.

 

[Beth Melton]

You can use a macro for this but you would need to run it each time
the cell content changes.

Sub UpdateFooter()
For Each Sheet In ActiveWorkbook.Worksheets
Sheet.PageSetup.CenterHeader = Sheet.Range("A1").Value
Next Sheet
End Sub

If you encounter problems utilizing the code or do not know how to
modify it, such as use RightFooter, LeftFooter, provided you may want
to post any follow-up questions to one of the Excel newsgroups since
this group is a Word newsgroup.

Here's a link to the Excel General Discussions group:
http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/