| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I place font buttons on the Toolbar
I constantly switch back and forth between Arial and Symbol fonts. Is there
a way I can place those specific fonts on my Toolbar as buttons so I can switch back and forth more conveniently? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I place font buttons on the Toolbar
Record a macro for each of your font changes, one for Arial and another for
Symbol, then right click on any visible toolbar and select CUSTOMIZE. Click the COMMANDS tab, scroll down until you find MACROS and select it. in the COMMANDS panel to the right of the CATEGORIES panel, click CUSTOM BUTTON and then click and drag it to the toolbar of your choice. The FORMATTING tool bar would be a natural for this button. Right click on your new button andin the NAME field type the name of the font that it will change to and then clck TEXT ONLY (ALWAYS). This will exit the menu, so right click once again on the new button and select ASSIGN MACRO. Select the macro of you choice from the list of available macros. Repeat the procedure for the second button -- Kevin Backmann "topsquark" wrote: I constantly switch back and forth between Arial and Symbol fonts. Is there a way I can place those specific fonts on my Toolbar as buttons so I can switch back and forth more conveniently? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I place font buttons on the Toolbar
A nice trick. Thanks!
"Kevin B" wrote: Record a macro for each of your font changes, one for Arial and another for Symbol, then right click on any visible toolbar and select CUSTOMIZE. Click the COMMANDS tab, scroll down until you find MACROS and select it. in the COMMANDS panel to the right of the CATEGORIES panel, click CUSTOM BUTTON and then click and drag it to the toolbar of your choice. The FORMATTING tool bar would be a natural for this button. Right click on your new button andin the NAME field type the name of the font that it will change to and then clck TEXT ONLY (ALWAYS). This will exit the menu, so right click once again on the new button and select ASSIGN MACRO. Select the macro of you choice from the list of available macros. Repeat the procedure for the second button -- Kevin Backmann "topsquark" wrote: I constantly switch back and forth between Arial and Symbol fonts. Is there a way I can place those specific fonts on my Toolbar as buttons so I can switch back and forth more conveniently? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing Macro Buttons on Toolbar | Excel Discussion (Misc queries) | |||
| Toolbar buttons -- AS400 iSeries Transfer | Excel Discussion (Misc queries) | |||
| I keep losing Toolbar buttons | Excel Discussion (Misc queries) | |||
| How can I keep Toolbar Buttons on the toolbar? | Setting up and Configuration of Excel | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
