View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John M[_5_] John M[_5_] is offline
external usenet poster
 
Posts: 10
Default 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