I'm looking to build a macro to apply coloring to worksheet tabs. I can (and have) used record macro to pick up the code to actually apply the color to the tab of the current active sheet. I now need a way to expand that so that a user can selected multiple tabs at once before they start the macro and have the macro apply the same color to the tabs for the sheets that were selected at the macro's start.

So what I was thinking I would do is create a loop statement that goes through each of the worksheets in the workbook, checks if they are active, and if so applies the coloring to their tab.

Trouble is I can't find a way to tell if a given sheet is selected when multiple sheets are selected. Any help in doing that is much appreciated.