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

excel 2007 customize quick access toolsbar adding menus commands 3
Excel Quick Access Toolbar Commands not working? 3
Can Quick Access Toolbar be expanded to 2 rows? 2
Losing Customizations On Quick Access Toolbar When I Reopen File 2
How do I add subscript/superscript font to the Excel toolbar?? 1
quick access toolbar 3
Document Specific Quick Access Toolbar 1
2007: Property Sheet button disabled 5

Top