Adding toolbar buttons for colors?

[cheetahlip]

Is it possible to add a seperate toobar button for a highlight color you use quite frequently?

Thanks!

 

[damian_r]

Hi,

You could always trying recording a macro to fill a cell with a colour by holding down ctrl+ a letter of your choice.

I've got 3 colour macros set up for my own use (one of them actually emties the colour from the highlighted cells)


Damian

 

[zoso]

Hi there!

Right click on the sheet tab > View code
In top left hand window select VBA Project
Right click again Insert>Module

Now paste this in:

Sub FillCellyellow()

With Selection.Interior
.ColorIndex = 6 'or whatever colour you're after
.Pattern = xlSolid
End With
End Sub

Now create a custom macro button, right click and assign 'fillcellyellow' macro to it.

Hope that helps!

 

[cheetahlip]

Zoso and Damian.....Thanks a bunch!! worked like a charm!!!!

Hey Damian, what's the code you used for clearing the color out? I don't like using white because it erases the gridlines.....

 

[damian_r]

i just created a macro with ctrl+E being no fill

 

[zoso]

Hi again.

Just insert this into the same module and assign the 'nofill' macro to second button:

Sub nofill()
Selection.Interior.ColorIndex = xlNone
End Sub

HTH!

 

[cheetahlip]

NICE!!!!! Thanks ZOSO!!!!

My life is getting easier all the time thanks to this message board!!!!!!!

 

[cheetahlip]

PROBLEM!!! It's a pain in the boot!!

BAD BAD news!!!!!! I added the custom buttons and now my excel goes wacky on me.....the buttons no longer show up, and now toolbars reset and disappear every time I restart excel, and sometimes when I don't restart.....what's causing this mess to happen?????

 

[cheetahlip]

anyone???