footer date

  • Thread starter Thread starter Cecelia Claybrook
  • Start date Start date
C

Cecelia Claybrook

Is there a way to automate the changing of a date in the
footer only when a change has been made in the data.
e.g. Revised on <date>.
 
Excel doesn't have a feature that changes the footer when a cell is changed.
You could run a macro to make it easier to enter the new footer, e.g.,

ActiveSheet.PageSetup.CenterFooter = _
"Revised on " & Format(Now, "m/d/yyyy")
 
Back
Top