How do I use a function in a footer?

K

KHNorton

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!
 
C

Chip Pearson

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
 

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

Section and Page numbering 0
I need help with removing the header & footers on the last page in word 2010 7
Page numbering with Merged Document and IF statements 1
Automatically insert "Continued" in footer based on existing STYLEREF 2
Footer On Last Page Only Not Working 1
Need VBA Macro to Loop through pages and print counter in footer of each page 9
How to save a PDF with header that extends to edge of page? 3
Project Professional 2016 - Headers and footers not showing up in print preview & printed document 2

Top