Remove macro warning

[Neil Perry]

Hi -

I have a spreadsheet that I take some raw data that I run a macro on to
clean the data then (once the macro is complete) I send it on to managers in
my department. I don't want to send the file with the macro held within it,
so I remove it from the copy I send out.

The thing is, even with the macro deleted, when people open the file, they
still get a message offering them the choice to enable macros, even though
there is no macro.

Can anyone tell me how I go about removing the reference to the macro so
that this message no longer appears?

Thanks
Neil

 

[Neil Perry]

Thanks - That worked.

Hi, Neil Perry

Delete the module, not only the code.