If you use the Custom Footer option, you can type in whatever you like. I could not find a way to enter the data so that it updates based on your computer's internal settings,
, or you might want to store it in the workbook module. Rightclick the Excel icon left of "File" in the menu bar, choose "View Code". Then paste this in.
Private Sub WorkBook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = Format(Now, "mmm-dd-yy")
End Sub
BeforePrint is covered in VBA Help.
Rgds,
Andy
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!