adding commands to Quick Access toolbar

J

Jake

Dear
for Excel 2007. how can i add the following commands to Quick access toolbar:

Home>Font> Superscript
and
Home>Font> Subscript

i was trying to find them in the list of (all commands) but i couldnt find
them :-(

if there is no such a commant to add to the toolbar what is the keyboard
comand for it?

any help please xx
 
R

Ron de Bruin

Hi Jake

I also can't find them

You can add a macro button to the QAT and assign code like this to it

With Selection.Font
.Superscript = False
.Subscript = True
End With

See this page how you can assign your macro to a button
http://www.rondebruin.nl/qat2.htm
 

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

Similar Threads

How do I stop the Commands from disappearing from Quick Access too 0
Designate font as italic of another 0
Losing Customizations On Quick Access Toolbar When I Reopen File 2
Can Quick Access Toolbar be expanded to 2 rows? 1
Excel Quick Access Toolbar Commands not working? 3
Can I edit macro buttons on the quick access toolbar in excel? 0
excel 2007 customize quick access toolsbar adding menus commands 3
Customize Quick Access Toolbar 5

Top