ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control-Home key behaviour (https://www.excelbanter.com/excel-programming/442416-control-home-key-behaviour.html)

K_Macd

Control-Home key behaviour
 
Not neccessarily a coding issue but this forum has a far greater knowledge
depth than others. Recently the above key combination rather than making cell
A1 the active cell now makes the column A cell in the current row the active
cell. Ctrl_Home in VBE achieves the correct result, that is, the cursor is
relocated to the first line & character of the module. I have tried
'application.onkey "^{Home}" "" ' in the intermediate window but without any
effect. I have also removed any add-ins and disabled auto opening macro
files. Any clues ?

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"

Dave Peterson[_2_]

Control-Home key behaviour
 
There's a setting to allow Excel to behave more like Lotus 123.

In xl2003 menus:
tools|options|transition tab|uncheck all those options



K_Macd wrote:

Not neccessarily a coding issue but this forum has a far greater knowledge
depth than others. Recently the above key combination rather than making cell
A1 the active cell now makes the column A cell in the current row the active
cell. Ctrl_Home in VBE achieves the correct result, that is, the cursor is
relocated to the first line & character of the module. I have tried
'application.onkey "^{Home}" "" ' in the intermediate window but without any
effect. I have also removed any add-ins and disabled auto opening macro
files. Any clues ?


--

Dave Peterson


All times are GMT +1. The time now is 10:04 PM.

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