ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keyboard shortcut (https://www.excelbanter.com/excel-discussion-misc-queries/199116-keyboard-shortcut.html)

GKW in GA

Keyboard shortcut
 
How do I assign a keyboard shortcut to a tool bar button

Gary''s Student

Keyboard shortcut
 
Most buttons already have shortcuts assigned. See:

http://www.microsoft.com/downloads/d...DisplayLang=en

If a pre-assigned shortcut does not exist, replicate the button's action and
assign a shortcut to the macro. There may not be a shortcut to make a cell
superscript, so make a macro:

Sub Macro1()
Selection.Font.Superscript = True
End Sub

and assign a shortcut to it
--
Gary''s Student - gsnu200800


"GKW in GA" wrote:

How do I assign a keyboard shortcut to a tool bar button


GregNga

Keyboard shortcut
 
This is a .bin file. How do you read it?

"Gary''s Student" wrote:

Most buttons already have shortcuts assigned. See:

http://www.microsoft.com/downloads/d...DisplayLang=en

If a pre-assigned shortcut does not exist, replicate the button's action and
assign a shortcut to the macro. There may not be a shortcut to make a cell
superscript, so make a macro:

Sub Macro1()
Selection.Font.Superscript = True
End Sub

and assign a shortcut to it
--
Gary''s Student - gsnu200800


"GKW in GA" wrote:

How do I assign a keyboard shortcut to a tool bar button



All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com