Getting list of theme colors

H

Han

Hello

How can I get list of theme colors as hex values?

Manually I can open the color window, apply one of them to a cell, and
saveAs the sheet as HTML. Then I can see the hex values. Boring. If
possible, I want to get every hex values, just hex values, with VBA.

Or, if impossible, can I apply every theme colors to cells of a sheet with
VBA? Then I can do the rest.
 

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

Changing "Office" theme colors 0
Backcolor value in hex 2
Drop down list control value in vba 2
Hide columns according to background fill color 2
Search other sheets for numbers & color them 10
How I can get color (RGB value) from .ThemeColor + .TintAndShade? 2
Colors 3
How can I get Hex values to appear in the Visio color information 1

Top