Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
  2. ActiveSheet.PageSetup.LeftHeader = "Company: Company Ltd." & Chr(10) & "Cutoff date: 31.12.20XX"
  3. ActiveSheet.PageSetup.LeftFooter = "Filename: &F" & Chr(10) & "Sheet: &A"
  4. ActiveSheet.PageSetup.CenterFooter = "Page &P of &N"
  5. ActiveSheet.PageSetup.TopMargin = Application.CentimetersToPoints(3.91)
  6. ActiveSheet.PageSetup.HeaderMargin = Application.CentimetersToPoints(1.91)
  7. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement