I have added the Calculator to the QAT and now want to assign it keyboard keys. I cannot find Formula (which is what the icon says when cursor hovers) nor Calculator in any of the Choose Commands from choices.
How can I go about assigning keyboard keys. I tried creating a macro but got bogged down (never saw Record Macro). Should I persevere there, or is there another way?
Thank you.
Word 2013-QAT item, assign shortcut keys
-
- 3StarLounger
- Posts: 277
- Joined: 04 Aug 2010, 19:50
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Word 2013-QAT item, assign shortcut keys
The Calculate command itself can only be added to the ribbon or to the Quick Access Toolbar. You cannot assign a keyboard shortcut to it, you must click the button.
You could create a macro in your Normal.dotm template:
or alternatively
and assign a keyboard shortcut to it
You could create a macro in your Normal.dotm template:
Code: Select all
Sub Calc()
On Error Resume Next ' suppress errors
MsgBox "The result is " & Selection.Calculate, vbInformation
End Sub
Code: Select all
Sub Calc()
On Error Resume Next ' suppress errors
Application.StatusBar = "The result is " & Selection.Calculate
End Sub
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 277
- Joined: 04 Aug 2010, 19:50
Re: Word 2013-QAT item, assign shortcut keys
Hans - Perfectly PERFECT
Thank you so much
As always, your quick response is much appreciated.
Thank you so much
As always, your quick response is much appreciated.