Formatting results of .RightFooter = ActiveWorkbook.Keywords after results pulled
Posted on 2010-01-07
Well, I'm feeling mighty stumped! I finally got the file keywords to appear in a footer, but no of the font formatting combinations I add to the line are working. Lots of "Complie errors" = massive frustration! Below is the essence of the simple code...please help me figure out what I'm doing wrong. As you can see, I've commented out the formatting but wanted you to see it.
.LeftFooter = "&""Times New Roman,Regular""&12 &P"
' .RightFooter = "&""Times New Roman,Regular""&8"
.RightFooter = ActiveWorkbook.Keywords