In the Project Explorer window, you will see entries similar to the following: To edit code 'behind' a worksheet or a workbook:Īctivate the Visual Basic Editor (press ALT+F11).

In Excel, VBA code can be stored in three different locations: in a Visual Basic module, in a Visual Basic class module, and 'behind' worksheets and workbooks. In the Project Explorer in the Visual Basic Editor, activate the workbook that contains the code in question.Īfter the new module is inserted, cut the code from its original location and paste it into the Visual Basic module. You must insert a Visual Basic module into the workbook and then place the code in the new module. In order for automatically-running subroutines to work correctly in Microsoft Excel, they must be contained within a Visual Basic module. The code is not contained in a Visual Basic module, but 'behind' a worksheet or the workbook itself. The code in question is contained inside an automatically-running subroutine, such as an Auto_Open or Auto_Close subroutine. This will occur if both of the following conditions are true: In Microsoft Office Excel, Microsoft Visual Basic for Application (VBA) macro code that is contained 'behind' a worksheet or workbook may not work correctly. For a Microsoft Excel 97 version of this article, see 157346.įor a Microsoft Excel 98 version of this article, see 182482.

Visual basic for excel 2010 book