Tom’s Tutorials For Excel: Careful! That was *Alt*+F11 !
From your active workbook, a fast and easy way to get into the Visual Basic Editor is to press
Alt+F11 on your keyboard. You can do this from any worksheet.
Careful, that was
Ctrl key is commonly used in conjunction with other keys for keyboard shortcuts. By force of habit, you might mistakenly press
Ctrl+F11 instead of
Alt+F11 when attempting to go to the VBE.
Ctrl+F11 has a curious result. You won’t be taken to the VBE, but instead you will have created and find yourself on an outdated type of sheet called a macro sheet, with the strange tab name of Macro1. What’s up with that?
Prior to Excel version 97, macros were stored on macro sheets, which can still be created, though they have no practical use with today’s Excel, and they no longer hold any programming code. It’s OK to just delete the macro sheet if you create one, and take another stab at the
Alt key with
F11 to get into the VBE.
What have I done in excel if I press ‘home’ on my laptop and get a new chart instead of going to the beginning of the line?
That’s a new one. If you are sure you pressed the Home key and nothing else was selected while you did that, and if there is no programming code involved whatsoever, then I cannot even guess.