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
 
Top