ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Re-bind built-in Excel functionality to new OnKey event. (https://www.excelbanter.com/excel-programming/295352-re-bind-built-excel-functionality-new-onkey-event.html)

R Avery

Re-bind built-in Excel functionality to new OnKey event.
 
I want to replace CTRL-ALT-LEFT Arrow keybinding to one of my macros,
but I do not want to replace the builtin Excel functionality that
already exists for that shortcut. It is simple enough to replicate with
VBA code and bind that to a different key, but is there anyway to bind a
built-in Excel function to a different key?

Any help would be most appreciated!

Tom Ogilvy

Re-bind built-in Excel functionality to new OnKey event.
 
Can you assign the functionality of CTRL+ALT+LEFT arrow to another key - is
that your question. No.

You would have to write a macro that accomplishes that functionality and
assign that macro to the candidate key.

--
Regards,
Tom Ogilvy


"R Avery" wrote in message
...
I want to replace CTRL-ALT-LEFT Arrow keybinding to one of my macros,
but I do not want to replace the builtin Excel functionality that
already exists for that shortcut. It is simple enough to replicate with
VBA code and bind that to a different key, but is there anyway to bind a
built-in Excel function to a different key?

Any help would be most appreciated!




R Avery

Re-bind built-in Excel functionality to new OnKey event.
 
Yes, that is what I wanted to know. Thanks.

Tom Ogilvy wrote:

Can you assign the functionality of CTRL+ALT+LEFT arrow to another key - is
that your question. No.

You would have to write a macro that accomplishes that functionality and
assign that macro to the candidate key.



All times are GMT +1. The time now is 01:42 PM.

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