Thread: Modules
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Rich is offline
external usenet poster
 
Posts: 298
Default Modules

I am trying to write a piece of VBA that takes a copy of a workbook, deletes
various sheets, deletes the module that is attached to the sheet and then
e-mails it to a list of recipients.

I have managed to acheive everything EXCEPT the deletion of the module. Can
anyone give me the code to delete "Module1" from my workbook using VBA.

Thanks,

Rich