Delete macros in another macro

[John M]

I e-mail a spreadsheet to obtain a wide range of user information. The file has many graphic objects, controls and macros controlling user action and responding. Following the user's response I have the data e-mailed back by macro, but do not need the macro's or any user interface anymore. The file is 660KB in size (with the macros). After deleting all graphic objects, text and formats, the file that gets e-mailed is still 490KB in size. There are ± 700 event handlers in the macros. These can all be deleted before e-mailing
Is there a way to address macro modules from another macro, specifically to delete them

 

[Ron de Bruin]

Hi John

See this webpage
http://www.cpearson.com/excel/vbe.htm

You can use my sendmail Add-in also to do what you want
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

I e-mail a spreadsheet to obtain a wide range of user information. The file has many graphic objects, controls and macros

controlling user action and responding. Following the user's response I have the data e-mailed back by macro, but do not need
the macro's or any user interface anymore. The file is 660KB in size (with the macros). After deleting all graphic objects, text
and formats, the file that gets e-mailed is still 490KB in size. There are ± 700 event handlers in the macros. These can all be
deleted before e-mailing.

 

[John M]

Thanks. These links solve my problem. It has been most helpfu
Regards