How can I remove all traces of XLM macros?

  • Thread starter Thread starter keithb
  • Start date Start date
K

keithb

I have a spread-sheet that thinks it still has an XLM macro. I cannot find
the macro in the macro sheet. Does anybody have any suggestions as to how I
can find this macro? (when security is set to "Medium" the sheet opens with
the option to enable/disable macros. If you choose to "disable" the sheet
comes back with the warning that the macro was created with Excel v4 (XLM)
and cannot be disabled)

Thanks,

Keith
 
Hi Keith,

In the visual basic editor (press 'Alt' & 'F11'), try deleting the module.
It will probably be named 'Module 1'. Save and reopen. This should do the
trick!!
Let me know if this works!
www.spreadsheetsolutions4u.com
 
Keith-

The mere presence of an Excel 4 macro sheet, even if empty, will trigger
this warning. So as Norman said, you must delete any such sheets.
 
The 'Macro1' sheet does not show up in the IDE; however it does show up in
the normal Excel spreadsheet view and I was able to delete it.

Thanks,

Keith
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using XLM Macro Sheet in Excel 2010 1
Windows XP How can I remove all traces of XLM macros? 0
Old Excel 2000 macro won't run under Windows XP 2
2007 vs 2003 2
vba equivalent of an autorun xlm file 3
Can Excel 2007 run ".xlm" macros? 2
How to choose a sheet in a workbook with the old Excel XLM ? 1
International Excel 4 Macro 4

Back
Top