Excel 2003 -- Add "Solver" to toolbar

I use Excel 2003... I'd like to add the "Solver" add-in to my toolbar.

When clicking on "Tools | Customize | Commands (tab) | Tools", I don't see the Solver add-in as part of the options.    Just in case, I've also checked the other menus (e.g., Edit, Format, etc.).

For Excel 2003, how can I create a shortcut (macro if necessary) to have this tool only a mouse-click away?

Thanks,
EEH
ExpExchHelpAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rory ArchibaldConnect With a Mentor Commented:
Again:
"View-Toolbars-Customize, then click the Tools menu and drag the 'Solver...' button wherever you want. "

The Solver... button is not listed in the Commands list because it is not a built-in button.
0
 
Rgonzo1971Commented:
0
 
Rory ArchibaldCommented:
You have to install the add-in first, which will add a menu item to the Tools menu. If you want to move that, you can do the usual View-Toolbars-Customize, then click the Tools menu and drag the 'Solver...' button wherever you want.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
ExpExchHelpAuthor Commented:
Yes, the Solver add-in is already loaded/installed.    It currently is accessible only going through the "Tools | Solver" menu.

I've already gone to the Toolbars/Customize... it's not displayed there in order to drag it to the toolbar.

What's missing?

EEH
0
 
ExpExchHelpAuthor Commented:
rorya:

Sorry, I misunderstood... thanks!   That worked like a charm!  ;)

Tom
0
 
Rory ArchibaldCommented:
No problem, Tom. :)

IIRC, you can also Ctrl+click and drag to create a copy of the button somewhere else and leave the original in place.
0
 
ExpExchHelpAuthor Commented:
Great idea... thanks, rorya!    I appreciate your assistance.

Tom
0
 
Rory ArchibaldCommented:
You're welcome.

It's just Rory, by the way. ;)
0
 
ExpExchHelpAuthor Commented:
Thanks, Rory... my apologies.   I copied/pasted your EE username.

Cheers,
EEH
0
 
Rory ArchibaldCommented:
I know - most people do. I've become too lazy and don't bother signing my posts anymore (hint to EE: a signature facility would be nice).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.