How do I use a function in a footer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to use a function in a header or footer? I'd like to be able
to include the date the file was last saved.

Thanks!
 
You can't put a function or formula in a header or footer. In
your case, you can use VBA code to set the Left/Center/Right
Header/Footer to the last save date.

ActiveSheet.PageSetup.CenterHeader = _
ThisWorkbook.BuiltinDocumentProperties("Last Save Time")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header/Footer Date Format 2
Excel Unique last page footer 1
HEADER & FOOTER 1
Last Saved By 3
Header and Footer 1
Automatic update of footer macro 2
Header or Footer - Reference a Cell 5
Pictures in Headers and Footers 1

Back
Top