deleting a blank macro

  • Thread starter Thread starter Les Ankersen
  • Start date Start date
L

Les Ankersen

I have an Excel file that is linked to my cad program, when I open the Excel
sheet form cad I get an error about disabling macros,
this can after I accidentally hit the macro button in excel. I want to
remove the macro in the excel sheet. There isn't any thing in the macro.

Thanks
les
 
The macro warning isn't very smart. If there are any modules in the
workbook, delete them (even if there is no code in the modules).

If the message persits, go to every code page (workbook, worksheet,
forms etc.) and Edit|Select All then press the delete key (even if there
appears to be no code, since even a space on a code page would trigger
the warning).

If the message still persits, try the code at
http://groups.google.com/groups?selm=etcItvDs$GA.194@cppssbbsa04
In early flavors of Excel 97 SR-2, Excel mistakenly interprets some
hidden names left by Solver as evidence of Excel 4 macros.

Jerry
 
Back
Top