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. VBA code "behind" a worksheet or a workbook may not work in Excelįor a Microsoft Excel 97 version of this article, see 157346.įor a Microsoft Excel 98 version of this article, see 182482.
0 Comments
Leave a Reply. |