Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Use the BeforePrint event to add information to a header or footer before the sheet is printed
Private Sub Workbook_BeforePrint(Cancel As Boolean)
    ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName
End Sub