VBA color palette

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way of changing/modifying the colors in the vba color palette,
to match colours I have modified in Excel. My reason for wanting this is to
match command buttons etc, to the sheet in which they occur. Many thanks in
anticipation.
 
Hi,

When you look at the color palette for any color in the "Properties
window", right click a blank square in the last two bottom rows,
It will open a the customisation color palette.
Regards,
JY
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to change default color palette 1
Retrieve Excel Colors 2
Pick a color from the default palette 2
colour palette reset 2
Excel 2003 - Color codes 6
How to change the default interior color palette index in Excel 2003 1
How to get Excel to use a custom RGB color in a chart series? 5
Where (menu) find "fill color" and define/add a new color? 1

Back
Top