Change color on faceid 3077
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 *** |
Change color on faceid 3077
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" wrote in message ... 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 *** |
Change color on faceid 3077
Thanks for your answer. That was just what I want to do. Regards Rolf *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 11:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com