Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add fill colors: green & red & yellow on toolbar, instead clickin.
I want to add different colors on toolbar to fill cell color. Not having to
click on fill color box on toolbar to color cell each time. |
#2
|
|||
|
|||
hi,
create three macros, 1 for each color Sub macgetcolor() Selection.Interior.ColorIndex = 5 End Sub red = 5 green = 4 yellow = 6 Put an macro icon up for each color and assign 1 of the macro to each icon. modify the icon to reflect the color. if you don't like those colors then in a blank workbook paste and run this code. it will show you all of the colors in excel and their indexes. Sub macGetColors() ' Macro written 2/10/02 by FSt1 Sheets("Sheet1").Select Range("B2").Select Set ci = Range("A1") ci.Value = 1 Set c = Range("B2") Do Until ci 56 Set c2 = c.Offset(1, 0) Set cnum = c.Offset(0, 1) c.Interior.ColorIndex = ci.Value c.Offset(0, 1) = ci.Value ci.Value = ci.Value + 1 Set c = c2 c.Select Loop End Sub -----Original Message----- I want to add different colors on toolbar to fill cell color. Not having to click on fill color box on toolbar to color cell each time. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FILL COLORS | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Better Fill Colors? | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |