Forum Discussion
Customised Font colour -How to save
One option would be to create a macro that applies the desired color to the sheet tab. If you create the macro in your personal macro workbook PERSONAL.XLSB, it will be available in all workbooks.
You can assign the macro to a custom Quick Access Toolbar button if desired.
Otherwise, I fear you'll have to apply the color to a cell first. It will then be available in the Recent Colors list during the session. I don't know of another way to make it available there.
You might create a custom style for each color. Make sure that the style affects only the font:
They will become available in Cell Styles on the Home tab of the ribbon.
If you want to use the same styles in another workbook, you can merge styles between two open workbooks.
Follow up question : If I want to customise the color of a tab name, according to a pre-defined customised color, how could it be done ?
One option would be to create a macro that applies the desired color to the sheet tab. If you create the macro in your personal macro workbook PERSONAL.XLSB, it will be available in all workbooks.
You can assign the macro to a custom Quick Access Toolbar button if desired.
Otherwise, I fear you'll have to apply the color to a cell first. It will then be available in the Recent Colors list during the session. I don't know of another way to make it available there.
- Wow ! Works well. Thanks for your help !