-
VBA Excel Margin Problem
Hi all,
I have several line of codes to change the "Page set up" properities of my report.
With ActiveSheet.PageSetup
.PrintArea = ""
.LeftFooter = "XXX"
.RightFooter = "YYY"
.LeftMargin = Application.InchesToPoints(0.2)
.RightMargin = Application.InchesToPoints(0.2)
.TopMargin = Application.InchesToPoints(0.2)
.BottomMargin = Application.InchesToPoints(0.32)
.HeaderMargin = Application.InchesToPoints(0.05)
.HeaderMargin = Application.InchesToPoints(0.2)
.FooterMargin = Application.InchesToPoints(0.27)
End With
It works perfectly well with my notebook as well as my colleagues's notebooks. However, when it comes to my Boss's notebook, the set up of margin just doesnt work !!! (Left Footer and Right Footer both work).
Can anyone help me to get ride of this frustration.
Thanks.
Regards,
Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules