View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_2_] Dave Peterson[_2_] is offline
external usenet poster
 
Posts: 420
Default 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