Hello Mr Excel gurus,
As the title says, I'm trying to make a simple macro to apply to a button, so I can update the footer details of a Worksheet.
I can accomplish all of these steps individually, however when I manipulate the "font colour" property, I can't seem to get things to work with variables other than those which are predefined, such as "&D", etc. I'm hoping there is a work around here...?
I've been stabbing in the dark at different syntax "strategies" (lol) for a couple hours now, and am at the point where I'm hoping someone out there might be able to help!
I wouldn't have thought footer font colour would bring so much grief...!?
If you know anything about footer properties, you will be able to see what I'm trying to achieve.
Any assistance would be incredible.
Cheers,
Dan
As the title says, I'm trying to make a simple macro to apply to a button, so I can update the footer details of a Worksheet.
I can accomplish all of these steps individually, however when I manipulate the "font colour" property, I can't seem to get things to work with variables other than those which are predefined, such as "&D", etc. I'm hoping there is a work around here...?
I've been stabbing in the dark at different syntax "strategies" (lol) for a couple hours now, and am at the point where I'm hoping someone out there might be able to help!
I wouldn't have thought footer font colour would bring so much grief...!?
If you know anything about footer properties, you will be able to see what I'm trying to achieve.
Any assistance would be incredible.
Cheers,
Dan
Code:
Sub Refresh_Footer_Details()
With ActiveSheet.PageSetup
.LeftFooter = "&K808080Profile - ""&Range(B2).Text"
.CenterFooter = "&K808080Format(Date, "dddd dd mmmm yyyy")"
.RightFooter = "&K808080Page &P of &N"
End With
End Sub
Last edited: