TWO DIFFERENT FILL COLOURs ON MENU BAR

K

Kirstoff

Can anyone help?
All i want is to have 2 'fill colour' icons on my tool bar, each with
different colours, but whenever i change one, the other changes too!
 
J

JE McGimpsey

You can't put the same control twice on a toolbar and have different
button displays. If at least one of the colors will always be the same,
you could record a macro, store it in our Personal.xls workbook (or an
add-in or other workbook in your startup folder), and attach it to a
button. Perhaps something like:

Public Sub FillBlue()
If TypeOf Selection Is Range Then
Selection.Interior.Color = RGB(0, 0, 255)
End If
End Sub
 
E

Elisabeth

You can drag the fill color menu onto your worksheet. All of the standard
fill colors are then visible and you can easily select the one you want.
 
Top