Can I have 2 different FILL buttons in the ribbon. One yellow and one blank?

[Sylcarry87]

Running Office 2010, windows 10, 64bit.

So really I want a shortcut/hotkey that removes the fill from selected cell/s.

I added another fill button to my custom group on the ribbon, but when I change the fill color of the one, it changes the fill color of the other.

I want to have a dedicated NO FILL button, shortcut, hotkey to apply no fill.

Thanks.

 

[Alan_P]

Hi Sylcarry87,

A simple macro would work

Press Alt+F11 -> Insert -> Module -> Paste Below;

Sub NoFill()
Selection.Interior.Pattern = xlNone
End Sub

On the developer tab click Macros -> Select "NoFill" -> Click Options -> Then assign a shortcut key i.e. "Ctrl + q"

Now Ctrl+q will be a shortcut to remove fill from whatever is selected...

If the developer tab is not visible go...File -> Options -> Customize Ribbon -> On the right hand side tick developer box (usually the only one not ticked)

Hope this helps,
Cheers,
Alan.

 

[Sylcarry87]

Thanks so much Alan. You just saved me a ton of miles on my mouse!!

 

[Alan_P]

No problem, happy to help

If you want to save more mouse miles you could do the same for your yellow fill and set it do another shortcut key

Sub YellFill()
With Selection.Interior
    .Pattern = xlSolid
    .Color = vbYellow
End With
End Sub