View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
david mcritchie david mcritchie is offline
external usenet poster
 
Posts: 691
Default Removing a module with code

Hi Kimberly,
See Chip Pearson's "Deleting A Procedure From A Module" within
Programming To The VBE
http://www.cpearson.com/excel/vbe.htm

You should be able to change ThisWorkbook.
to something like Workbooks("BOOK1").
and change the obvious things for module

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"KimberlyC" wrote in message ...
Hi

Is it possible to remove a module (with code) that is located in another
workbook.
Here's what I need to do:
I would like to run code from an addin file that would remove module1 in the
activeworkbook .

Any help would be greatly appreciated.

Thanks!
Kimberly