hi all,
i'm trying to execute a macro (with will adjust the footer) and it needs to run everytime a workbook is opened.
I allready have an add-in with some macro's so i will add it to the add-in
this needs to be triggered on opening any workbook for the opened workbook....
is this possible?
thanx a lot!
david
i'm trying to execute a macro (with will adjust the footer) and it needs to run everytime a workbook is opened.
I allready have an add-in with some macro's so i will add it to the add-in
Code:
With ActiveSheet.PageSetup
.LeftFooter = "&Z&F" & Chr(10) & "&D"
.BottomMargin = Application.InchesToPoints(0.75)
.FooterMargin = Application.InchesToPoints(0.4)
End With
this needs to be triggered on opening any workbook for the opened workbook....
is this possible?
thanx a lot!
david