asked on 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
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
Microsoft Excel
Last Comment
Rory Archibald
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.
ASKER
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
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
rorya:
Sorry, I misunderstood... thanks! That worked like a charm! ;)
Tom
Sorry, I misunderstood... thanks! That worked like a charm! ;)
Tom
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.
IIRC, you can also Ctrl+click and drag to create a copy of the button somewhere else and leave the original in place.
ASKER
Great idea... thanks, rorya! I appreciate your assistance.
Tom
Tom
You're welcome.
It's just Rory, by the way. ;)
It's just Rory, by the way. ;)
ASKER
Thanks, Rory... my apologies. I copied/pasted your EE username.
Cheers,
EEH
Cheers,
EEH
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).
Have you loaded the Solver
http://office.microsoft.com/en-us/excel-help/load-the-solver-add-in-HP001127725.aspx
Regards