Customize Toolbar for Superscript/Subscript

C

c308682

Using Excel 2004 for MAC OS X, I don't find a a toolbar button for
superscript and subscript under the Tools / Customize, like Excel for
Windows has?

Is there another way to get a "shortcut" to toggle the font to and from
super/subscript?

Thanks.
 
J

JE McGimpsey

c308682 said:
Using Excel 2004 for MAC OS X, I don't find a a toolbar button for
superscript and subscript under the Tools / Customize, like Excel for
Windows has?

Is there another way to get a "shortcut" to toggle the font to and from
super/subscript?

Well, you can use the buttons on the Formatting Palette...

Don't know why those buttons aren't in the customization dialog, but you
can easily add them to toolbars...

Type Opt-F11 to enter the Visual Basic Editor (VBE).

Type CMD-g to open the Immediate Window.

In the Immediate Window, type or paste

CommandBars("Standard").Controls.Add Id:=57

and

CommandBars("Standard").Controls.Add Id:=58

each followed by Return.

Type Opt-F11 to return to XL.

You can now move those buttons like any others in the Customize U/I.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top