Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
You get a macro warning when no macros exist
Posted by - NA - on 21 March 2006 07:30 AM
|
|
|
Solution: When you open a workbook, you may be prompted to enable or disable macros --even though no macros exist in the workbook. Press Alt+F11 to activate the Visual Basic Editor. Locate your workbook in the projects window: 1.If the workbook contains any VBA modules (for example, Module1), delete the module. Even an empty VBA module may trigger the macro warning. 2.Examine the code modules to ThisWorkbook, and the code module for each Sheet (for example, Sheet1). Make sure that these modules do not contain any macro code. You cannot delete these code module, but they must be empty to avoid the macro warning dialog box. | |
 (135 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)