MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Mystery Macros part II

Posted by Shane on April 24, 2001 1:32 PM

This is part 2 of my message post yesterday. I have some inherited spreadsheets that have macros in them. The macros don't do anything and if I try to disable them upon opening the spreadsheets I get the message "This workbook contains a type of macro (Microsoft Excel version 4.0 macro) that cannot be disabled" In Tools, Macro, Macros the macros are listed but when I try to Run, Edit or Step Into any of them (Delete is not a highlighted option) I get the message 'Reference is not valid'. And they don't show up as Modules in Visual Basic Editor (Alt F-11). Any suggestions????

Posted by Chris Rock on April 24, 2001 1:49 PM

It might not work, but there is a free Excel Add-in called "ASAP Utilities" that you can get from - it has a feature that allows you to remove Macros and VBA code from your workbooks. It has dozens of other cool features, too.

Posted by Jerid on April 24, 2001 2:01 PM

Something like this happened to me before, older versions of Excel stored the macros in worksheets. I got a workbook from someone and those sheets were hidden.

Check to see if you have any hidden sheets.

The only other thing I could think of would be to make sure that there is no code in any of the sheets, if not copy them into a new workbook. That should solve your problem