If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing the Excel color palette
I want to be able to set the RGB value for a fill color in a macro. The
color palette does not have the soft pastels I want to use. The problem stems from the fact that changes to the color palette don't carry over if I open the worksheet on another computer. So using the ColorIndex(3) doesn't work. I would like to do something like ColorIndex(3)= RGB(223,156,78). Any ideas?? Thanks, Don |
#2
|
|||
|
|||
Changing the Excel color palette
Don
Does Sub RGBColour() Range("A1").Interior.Color = RGB(223, 156, 78) End Sub Help? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Don McClure" wrote in message ... I want to be able to set the RGB value for a fill color in a macro. The color palette does not have the soft pastels I want to use. The problem stems from the fact that changes to the color palette don't carry over if I open the worksheet on another computer. So using the ColorIndex(3) doesn't work. I would like to do something like ColorIndex(3)= RGB(223,156,78). Any ideas?? Thanks, Don |
#3
|
|||
|
|||
Changing the Excel color palette
I ran into the same problem very recently.
choose tools/option/color choose a color you don't want to use. click on Modify/standard choose the color you want to use click Ok I tried to use the RGB function, but Excel 2003 does some weird stuff with the RGB function. "Nick Hodge" wrote: Don Does Sub RGBColour() Range("A1").Interior.Color = RGB(223, 156, 78) End Sub Help? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Don McClure" wrote in message ... I want to be able to set the RGB value for a fill color in a macro. The color palette does not have the soft pastels I want to use. The problem stems from the fact that changes to the color palette don't carry over if I open the worksheet on another computer. So using the ColorIndex(3) doesn't work. I would like to do something like ColorIndex(3)= RGB(223,156,78). Any ideas?? Thanks, Don |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel 2003 changing saved print settings | George Applegate | General Discussion | 0 | November 1st, 2005 06:50 PM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Excel Hyperlinks changing on their own | tbrand68 | General Discussions | 2 | October 17th, 2005 01:49 PM |
Excel changing number formatting and source data in graphs on it's own!!! | JohnHamer | General Discussion | 2 | September 22nd, 2005 02:29 PM |
Changing worksheet tab color in Excel 2000 | Wong | Worksheet Functions | 1 | September 25th, 2003 05:53 AM |