Bob's code is correct but perhaps this will help a bit.
http://www.cpearson.com/excel/vbe.aspx
Also note that you are probably using before_close as your event. That event
fires When you hit the close button. If you cancel the close at that time
then the code has already executed and the spread sheet will remain open but
the module will be removed...
--
HTH...
Jim Thomlinson
"Jeff W." wrote:
Bob, I'm not sure I have put this in correctly,
I get a compile error in hidden module
I have an auto run macro that calls another sub to run and
I have put this at the bottom of the second sub
not sure if this is right, but it doesnt want to work.
the debugger hanfs on the SET part of the additional code
<Jeff
"Bob Phillips" wrote in message
...
Dim vbMod As Object
Set vbMod = ActiveWorkbook.VBProject.VBComponents(moduleName)
ThisWorkbook.VBProject.VBComponents.Remove vbMod
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Jeff W." wrote in message
...
I have a work book that gets copied and renamed by another application
and when it runs it automatically fills with data, and I would like to
make
it so after you close and reopen, it doesnt try to auto run again.
Is this possible? I guess I want to delete all autorun macros on exit?
Thanks
Jeff W.