ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro removal (https://www.excelbanter.com/excel-discussion-misc-queries/72176-macro-removal.html)

Mike Milmoe

Macro removal
 
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

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

Macro removal
 
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.



All times are GMT +1. The time now is 03:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com