Hey Prism, I have quite a few of the CC Programs as well - all the main ones anyway including the HTML editor, Pro Shops & the Colour Picker & about 6-8 others. My computer knowledge is woefully basic, I even had to google IDE to have any idea what it was. Haven't a clue about PHP though i have heard of it.
When you log on Jo I have an update on the spreadsheet especially for you.
I've done up a really simple table of Pixar movies & a couple of extra columns.
There are 5 functioning buttons - border, header background/font & body background/font.
Click on any of those function buttons & then click away at the colours & watch the table change colour automatically.
Not lifechanging but an interesting experiment.
Only curiosity is that when selecting either header or body text colour or border colour & then selecting white, it selects black. It works fine when selecting white for the background & all other colours seem to work fine all round. Changing the text/border colours manually to whitein the RGB selection works fine...
Rolly, when doing up the macro I did try looking around for how to convert the RGB value to the .color value but didn't find anything. Did a bit of trial & error & you can find the formula in cell L29 if you are curious... though you probably already knew that anyway;)
Way past my bed time... my son will be up in a few hours to greet the day & run his cars over my head.
PS. don't worry about overwriting the previous spreadsheet, I've added an "_02" to the end of the file name.
http://www.thelittlecashbookcompany.com
(a work in progress)
(a work in progress)
