Thank Mr. Adrew
My requirement is to add a footer with the page number on the right, the distance from the bottom (1cm), the style of footer text (Times new roman, 14pt)
Dear Mr. Andrew,
After I created the "myfoot" building block, and running your code
an error appears " the requested member of collection doesn't exists"
after I changed myfoot category, as follows
81.png
The error was gone, but nothing happened
Dear Andrew, can you use this attributes,
Code:
' Set font properties
With footer.Font
.Name = "Times New Roman"
.Size = 14
End With
I think it's better and easier
Thanks