Tom’s Tutorials For Excel: Careful! That was *Alt*+F11 !

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 *Alt*+F11! The 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.

Pressing 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.



Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*