ChloeLM
New Member
- Joined
- Apr 12, 2021
- Messages
- 5
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- Mobile
- Web
Hi everyone
I'm formatting a header/footer on my sheet. I've worked out how to change the font, size and whether it's bold. I'm struggling to change the font colour/tint though, it's not clear where the instructions go. I'm also not certain about what the code for this looks like, according to the help guide it's &K xx. S nnn but that gives me alot to go wrong!!
Based on the theme colour elsewhere I've used:
I'm trying to add the code to change the colour to the following three lines:
Please can anyone help me to understand what the instruction to change the colour looks like, and where it goes?
Any assistance gratefully received!
Thanks
Chloe
I'm formatting a header/footer on my sheet. I've worked out how to change the font, size and whether it's bold. I'm struggling to change the font colour/tint though, it's not clear where the instructions go. I'm also not certain about what the code for this looks like, according to the help guide it's &K xx. S nnn but that gives me alot to go wrong!!
Based on the theme colour elsewhere I've used:
VBA Code:
ThemeColor = xlThemeColorLight1
.TintAndShade = 0
I'm trying to add the code to change the colour to the following three lines:
Code:
FirstPage.RightFooter.Text = "&08&""DM Sans""Page &P of &N"
.FirstPage.CenterFooter.Text = "&10&""DM Sans""Confidential"
.FirstPage.LeftFooter.Text = "&""DM Sans""&08" & Range("A2")
Please can anyone help me to understand what the instruction to change the colour looks like, and where it goes?
Any assistance gratefully received!
Thanks
Chloe