Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
- ActiveSheet.PageSetup.LeftHeader = "Company: Company Ltd." & Chr(10) & "Cutoff date: 31.12.20XX"
- ActiveSheet.PageSetup.LeftFooter = "Filename: &F" & Chr(10) & "Sheet: &A"
- ActiveSheet.PageSetup.CenterFooter = "Page &P of &N"
- ActiveSheet.PageSetup.TopMargin = Application.CentimetersToPoints(3.91)
- ActiveSheet.PageSetup.HeaderMargin = Application.CentimetersToPoints(1.91)
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement