TWO DIFFERENT FILL COLOURs ON MENU BAR
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
In article ,
Kirstoff wrote:
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!
|