Getting rid of macro

  • Thread starter Thread starter Thore
  • Start date Start date
T

Thore

Hi all,

I "inherited" an Excel workbook from a colleague which
contained a macro. Now if I open the file I always get the
warning message that the file contains a makro. If I
choose to disable the macro, I get error messages related
to makros being disabled.

However, when I go to "Tools" --> "Marcos" there is not a
single maco shown. (Independent of whether I chose to
enable/disable the marco when opening the file).

My question is: How do I get rid of any trace of that
original macro in the workbook?

Rgds,
Thore
 
You must REMOVE the module that the macro was in.
alt F11>open the "project">right click module>remove>no
 
Back
Top