An answer to the question from Podcast 1209; how do you prevent the F1 key from opening Excel help. This episode shows two to assign the F1 key to Edit.
...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Make F1 be F2?
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
How this goes all the way back to episode, 1209.
Someone said hey! I hate.
Why go to press the [ F2 ] key, press F2 to put the cell in edit mode and I accidentally press [ F1 ].
Alright! An Excel help comes popping up.
There's no keyboard way to close that window and is there some way to make F1 automatically do [ F2 ], that was the question, from 1209.
Well, a couple of great responses.
Hamid wrote in and said, "Wait, there is a way to close Excel help, with the keyboard shortcut.
Just it's a windows keyboard shortcut that would close the open window. [ alt + F4 ]." Hold down the [ alt ] key and press[ F4 ].
We close that.
Alright! So, there first of all, it was a keyboard method.
The second idea and this was send in, by Revon.
Revon send in a macro.
Let me open up this macro here.
It's actually a pair of macros, pretty clever the way that, Revon set this up.
They will add content over here in the macro recorder first.
Macros in this workbook, 'Private sub work-book_open' and we say hey!
'Application.OnKey' means when you press the [ F1 ] key, we're going to run another macro and that macro you can call this whatever you want, you call it 'sendF2' and then here in module 1 to send up two macro uses 'application.Sendkeys' (|F2) to not send the [ F1 ] key.
but to send the [ F2 ] key.
Right, so now as long as this workbook is open.
I'm going to press F1, and we go into edit mode.
So, Excel help just will never pop up, instead it will go to edit of course.
If you needed Excel help, then you could come out here on the right-hand side and hit the help.
Most of the time, accidentally hit [ F1 ], instead.
Now, that would probably be best to put that in a personal macro workbook and probably best to put that in the macro, personal macro, workbooks that waits there all the time every time.
So, run and might be good.
So, a couple of alternatives there, either [ alt ] + [ F4 ] to close, help when you hit it accidentally or...
Macros for a while, what they comment...
I want to thank you for stopping by.
We’ll see you next time for another netcast, from MrExcel.
Make F1 be F2?
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
How this goes all the way back to episode, 1209.
Someone said hey! I hate.
Why go to press the [ F2 ] key, press F2 to put the cell in edit mode and I accidentally press [ F1 ].
Alright! An Excel help comes popping up.
There's no keyboard way to close that window and is there some way to make F1 automatically do [ F2 ], that was the question, from 1209.
Well, a couple of great responses.
Hamid wrote in and said, "Wait, there is a way to close Excel help, with the keyboard shortcut.
Just it's a windows keyboard shortcut that would close the open window. [ alt + F4 ]." Hold down the [ alt ] key and press[ F4 ].
We close that.
Alright! So, there first of all, it was a keyboard method.
The second idea and this was send in, by Revon.
Revon send in a macro.
Let me open up this macro here.
It's actually a pair of macros, pretty clever the way that, Revon set this up.
They will add content over here in the macro recorder first.
Macros in this workbook, 'Private sub work-book_open' and we say hey!
'Application.OnKey' means when you press the [ F1 ] key, we're going to run another macro and that macro you can call this whatever you want, you call it 'sendF2' and then here in module 1 to send up two macro uses 'application.Sendkeys' (|F2) to not send the [ F1 ] key.
but to send the [ F2 ] key.
Right, so now as long as this workbook is open.
I'm going to press F1, and we go into edit mode.
So, Excel help just will never pop up, instead it will go to edit of course.
If you needed Excel help, then you could come out here on the right-hand side and hit the help.
Most of the time, accidentally hit [ F1 ], instead.
Now, that would probably be best to put that in a personal macro workbook and probably best to put that in the macro, personal macro, workbooks that waits there all the time every time.
So, run and might be good.
So, a couple of alternatives there, either [ alt ] + [ F4 ] to close, help when you hit it accidentally or...
Macros for a while, what they comment...
I want to thank you for stopping by.
We’ll see you next time for another netcast, from MrExcel.
