keyboard shortcuts

H

Harvey Waxman

"Goal Seek" isn't available in the Tools section when creating a keyboard
shortcut. Is there any way to make this possible? Most other things seem to
be there.

Thanks

Excel X

--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me
 
J

JE McGimpsey

Harvey Waxman said:
"Goal Seek" isn't available in the Tools section when creating a keyboard
shortcut. Is there any way to make this possible? Most other things seem to
be there.
Click to expand...

Couple ways:

If you're in Panther, choose System Preferences/Keyboard/keyboard
Shortcuts, and add a keyboard shortcut for Excel (enter "Goal Seek...",
without quotes, as the exact command name - there are three periods, not
an ellipsis).

If you're not in Panther, enter this in a regular code module in your
Personal Macro Workbook:

Public Sub StartGoalSeek()
Dim dlgAnswer
dlgAnswer = Application.Dialogs(xlDialogGoalSeek).Show
End Sub

and put this in the ThisWorkbook code module of your Personal Macro
Workbook:

Private Sub Workbook_Open()
Application.OnKey "*%^g", "StartGoalSeek"
End Sub

then quit and restart XL.

This will make CMD-OPT-CTRL-g open the Goal Seek dialog. Change the
key(s) as desired (see the OnKey method in XL/VBA Help for help with
keys/modifier keys).
 
H

Harvey Waxman

JE McGimpsey said:
If you're in Panther, choose System Preferences/Keyboard/keyboard
Shortcuts, and add a keyboard shortcut for Excel (enter "Goal Seek...",
without quotes, as the exact command name - there are three periods, not
an ellipsis).
Click to expand...

I was sure they were an ellipsis. Thanks. It works.


--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me
 
Top