How can I remove all traces of XLM macros?
 

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

How can I remove all traces of XLM macros?
 

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

How can I remove all traces of XLM macros?
 

Hi Keith,

Try deleting the macro sheet.


---
Regards,
Norman



"keithb" wrote in message
...
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

How can I remove all traces of XLM macros?
 

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.

--
Jim
"keithb" wrote in message
...
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

How can I remove all traces of XLM macros?
 

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

"spreadsheetsolutions4u" m
wrote in message ...
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