Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
I want to set-up my Home key on keyboard to go to a particular cell and not
the begining. |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Doubt that that is a good idea but, here is how you can do that.
Reference http://msdn.microsoft.com/library/de...HV05203370.asp Sub botchup_home() Application.OnKey "{HOME}", "Alternative_Home" end sub sub unbotch_home() application.onkey "{HOME}", "" end sub Sub alternative_Home() range("F14").activate end sub Also some additional information in http://www.mvps.org/dmcritchie/excel/shortx2k.htm Please use your first and last name in newsgroups at least in these newsgroups it is a lot more friendly and shows an interest and desire to participate in helping others not necessarily in this newsgroup but anywhere, as opposed to just using newsgroups to get an answer.. It's a lot more friendly. And it can be really nice to recognize a name from some other area when someone asks for help in an area you are more familiar with. Of course you usually need more than just a first and last name to identify yourself a little more especially cross disciplines. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "wiskeyjruiz" wrote in message ... I want to set-up my Home key on keyboard to go to a particular cell and not the begining. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |