Custom Formatting in a Button

  • Thread starter Thread starter Artful Dodger
  • Start date Start date
A

Artful Dodger

Hello guys,
It sounds simple but I have not been able to find any help on th
topic.

I do lots of formatting in Excel XP. I do not want to alway
right-click on the cell(s) and go to the Format menu.
My Q is can I place an icon in the tool bar (I know how to do that
that will have the custom fomat I need for the cell.
Thank you.
Your help is much appreciated
 
One way:

Put a custom button on a toolbar and attach it to a macro like this,
stored in Personal.xls or another workbook in your XLStart folder:

Public Sub MyStyle()
With Selection
.Font.Bold = True
.Font.ColorIndex = 3
End With
End Sub
 
Back
Top