Add sub/superscript buttons to the Excel 2008 toolbar
Jul 09, '08 07:30:03AM • Contributed by: AKazak
Jul 09, '08 07:30:03AM • Contributed by: AKazak
There's a well-known problem in Excel 2008 (unlike Word 2008) where you as the user can't easily add the Subscript and Superscript formatting buttons to a toolbar -- these buttons appear in the Formatting Palette, but the commands don't appear in the Customize menu, meaning there's no apparent way to add them to a toolbar.
In Excel 2004, the same problem existed, but there's a Visual Basic for Applications workaround to add the buttons to the toolbar. Using that information, I created small AppleScript to add the needed buttons to the standard Formatting toolbar in Excel 2008: [robg adds: To use this hint, enter the above code in Script Editor, then click Run (Excel 2008 should be running when you do). When you switch back to Excel, you'll see the new buttons at the end of the Formatting toolbar. You can then activate the View » Customize Toolbars and Menus menu item, and drag the icons to new positions on the Formatting toolbar, or even onto a different toolbar.]
In Excel 2004, the same problem existed, but there's a Visual Basic for Applications workaround to add the buttons to the toolbar. Using that information, I created small AppleScript to add the needed buttons to the standard Formatting toolbar in Excel 2008: [robg adds: To use this hint, enter the above code in Script Editor, then click Run (Excel 2008 should be running when you do). When you switch back to Excel, you'll see the new buttons at the end of the Formatting toolbar. You can then activate the View » Customize Toolbars and Menus menu item, and drag the icons to new positions on the Formatting toolbar, or even onto a different toolbar.]
•
[13,757 views]
