ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Configure Built-in Font Color Command Button? (https://www.excelbanter.com/excel-programming/405993-configure-built-font-color-command-button.html)

Clare.Moe

Configure Built-in Font Color Command Button?
 
Excel 2003.

Can I read and/or set properties of built-in toolbar command buttons
from VBA?

In particular, I'd like to be able to set the font color property of
the built-in Font Color button on the Formatting toolbar without
modifying the active cell.

I don't mind doing my own research, but I'm not having any luck
finding references.

Ideas?

thanks,
cm

Clare.Moe

Configure Built-in Font Color Command Button?
 
On Feb 12, 11:48*am, "Clare.Moe" wrote:
Excel 2003.

Can I read and/or set properties of built-in toolbar command buttons
from VBA?

In particular, I'd like to be able to set the font color property of
the built-in Font Color button on the Formatting toolbar without
modifying the active cell.

I don't mind doing my own research, but I'm not having any luck
finding references.

Ideas?

thanks,
cm


Sorry for the duplicate posting ... I couldn't find yesterday's
posting this morning when I looked for an answer. (I'm posting through
Google Groups, and my original thread didn't show up when I browsed
the discussions, nor when I searched for it. *After* I had re-posted
I did more digging and found my OP by linking through "My Profile.")

cm



All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com