The Function is where the work is done but it has to be summoned by the Subs which pass in the particular colour that you want. You can make as many copies of the subs that you want colours for.

There is a finite number of highlight colours available and so the list of available constants is quite small. The easiest way to work out the special word for a colour is to start a macro recording and apply that highlight colour to some text and then look at what was recorded.

I don't use a Mac and don't know the process to add buttons to the ribbon while you are using Mac Office 2011. I notice you have updated your Office version since your first post - perhaps you can do a google search to find out how to put buttons on your ribbon or QAT (if it exists on Macs) to run a macro.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia