Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Don McClure
 
Posts: n/a
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
Patricia Shannon
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
excel 2003 changing saved print settings George Applegate Excel Discussion (Misc queries) 0 November 1st 05 07:50 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
I entered 11/22/2004 in excel workbook and it keeps changing to ## Firefly Excel Worksheet Functions 1 February 24th 05 07:11 PM


All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"