I have added a date modified code that was recommended by someone else in a forum somewhere. It works... however now the month (mm) is missing, and when i formulated the font size, it shows up at 409pts?? Does anyone have an idea of what I might be doing wrong?
Code is shown below.
Or... is there a better way to do this? My customer wants the date the file was modified to show up on the top of the sheet, in the header. And it should only show the date that it was modified, not the current date that you open the file.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
For Each ws In ActiveWorkbook.Worksheets
ws.PageSetup.RightHeader = "&""Arial""&I&7" & Format(Now, "mm/dd/yy")