TWO DIFFERENT FILL COLOURs ON MENU BAR

[Guest]

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!

 

[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

 

[Guest]

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.