Prev: One step further
Next: Unable to change "Enabled" state of an Excel 2007 ribbon galle
From: kalle on 23 Mar 2010 01:32


Hello

I'm using faceid 3077 in a menu I have created and which works well but
how do I change the color of the line?

If I use the Fill Color in the normal menu in Excel, change the line
color to the last used color.

Is it possible to do that by VBA-code?

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***
From: Peter T on 23 Mar 2010 05:34
The faceid is not relevant, at least not directly.

This adds the Line colour dropdown to your commandbar
cbr.Controls.Add ID:=1692
where cbr refers to the commandbar

If you want to programmatically change the line or border colour of some
object record a macro to get the basic syntax (at least you can do that in
2003- which I guess is what you are working with).

Regards,
Peter T

"kalle" <kalle(a)yahoo.com> wrote in message
news:uVSKIpkyKHA.1236(a)TK2MSFTNGP06.phx.gbl...
>
>
> Hello
>
> I'm using faceid 3077 in a menu I have created and which works well but
> how do I change the color of the line?
>
> If I use the Fill Color in the normal menu in Excel, change the line
> color to the last used color.
>
> Is it possible to do that by VBA-code?
>
> Thanks in advance
>
> *** Sent via Developersdex http://www.developersdex.com ***


From: kalle on 23 Mar 2010 07:07


Thanks for your answer.

That was just what I want to do.

Regards
Rolf

*** Sent via Developersdex http://www.developersdex.com ***
 | 
Pages: 1
Prev: One step further
Next: Unable to change "Enabled" state of an Excel 2007 ribbon galle