Macro removal

[Mike Milmoe]

I wrote a basic Macro for a Spreadsheet I was creating. I sent the form to a
few people. I later removed the macro, or thought I did, and re-sent to the
same people. Now they keep getting the Macro warning message. How do I
permenantly remove this macro from my form. Incidentally, I don't get the
message.

[Paul B]

Mike,
You also have to remove the modules on which the macros were stored have a
look here for details http://www.contextures.com/xlfaqMac.html#NoMacros
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mike Milmoe" <[email protected]> wrote in message
news:[email protected]...
>I wrote a basic Macro for a Spreadsheet I was creating. I sent the form to
>a
> few people. I later removed the macro, or thought I did, and re-sent to
> the
> same people. Now they keep getting the Macro warning message. How do I
> permenantly remove this macro from my form. Incidentally, I don't get the
> message.

[Kevin B]

If what you removed was a general module, I would check the workbook &
individual sheet modules to see if there's any code floating about.

As for your PC, set your macro security setting to High and see if you can
replicate what a happens on your coworker's machines on your PC when you
retieve the file in question.


--
Kevin Backmann


"Mike Milmoe" wrote:

> I wrote a basic Macro for a Spreadsheet I was creating. I sent the form to a
> few people. I later removed the macro, or thought I did, and re-sent to the
> same people. Now they keep getting the Macro warning message. How do I
> permenantly remove this macro from my form. Incidentally, I don't get the
> message.