Auto populate header w/ specific font and color

[Starmusk10]

Good morning,

I am using this macro to auto populate a header...

Please Login or Register  to view this content.

It works great, but I would like to control the font, size and color of the text in the header. Could someone please help me with adding that to the code?

Thanks,
Todd

[Winon]

Hello Starmusk10,

Thank you for adding Code Tags.

Regards.

[Starmusk10]

My apologies for not adhering to the rules. Thank you for pointing this out.

Todd

[Winon]

Hello Starmusk10,

Maybe something like this?

Please Login or Register  to view this content.

Regards

[Starmusk10]

That works, but it places the text and formatting into Cell A1 Instead of the left header.

[Winon]

Thank you for the feedback Starmusk10,

Then we revert to the following Code;

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Regards.

[Winon]

Hello Starmusk10,

I think the following will suit you better.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Regards.

[Starmusk10]

Thank you very much. This works perfectly!

Todd

[Winon]

Hi Todd,

Thank you for the feedback. Glad I could help, and that you have added to my Reputation. Also thank you for marking this thread as solved.

Kind regards.

W

[Starmusk10]

W,
How do I adjust the color and size of the font? I thought it would be pretty simple, I tried just replacing the HTML code (K0000FF), but I've gotten some funky stuff by doing that. I would like to customize the font, size and color.

Please Login or Register  to view this content.

Thanks,
Todd

[Winon]

Hello Todd,

Please see this Link for a list of HTML Color Numbers, and experiment with same.

You may have to remove the preceding #, if it does not Work. To change the Font, Enter any Font Name listed in the Font Select dropdown List available on the Excel Home Tab Sheet.

The size of the Font is Specified in Red, as shown below;

Please Login or Register  to view this content.

Regards.