Can I Delete A Module On Exit?
Did you replace the placeholder modulename with the actual name of the module
-- in quotes if it's a literal ??
On Wed, 31 Oct 2007 15:35:51 -0500, "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.
|