Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete macros in another macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete macros in another macro
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) www.rondebruin.nl "John M" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete macros in another macro
Thanks. These links solve my problem. It has been most helpfu
Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete macros | Excel Discussion (Misc queries) | |||
delete macros | Excel Worksheet Functions | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
How to delete macros | Excel Discussion (Misc queries) | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming |