If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deactivating the F1 key
I work extensively on Excel. While using the F2 edit key,
I accidently press the F1 key and suddenly the help starts when it is not needed. This takes quite some time off since help loads slowly. Is there a way i can deactivate my F1 key or assign another function key for help ? Thanks |
#2
|
|||
|
|||
Deactivating the F1 key
Maybe you could a line or two to your personal.xls (auto_open/workbook_open
procedure): Option Explicit Sub disableF1() Application.OnKey "{f1}", "" End Sub Sub enableF1() Application.OnKey "{f1}" End Sub There's at least one person who removes the keys he doesn't like (Hi, Chip!). You may want to pop the key off and take out that little springy thing. And then use the Help from the menu. Azhar Moinuddin wrote: I work extensively on Excel. While using the F2 edit key, I accidently press the F1 key and suddenly the help starts when it is not needed. This takes quite some time off since help loads slowly. Is there a way i can deactivate my F1 key or assign another function key for help ? Thanks -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|