Powerpoint Delete Module 1

[LGMan]

Hi, I have a 32 slide Powerpoint which uses links to various ranges on an Excel workbook. Everytime I open the PP presentation and have updated the links, I run a macro which saves the file to a new name (and protects my Master) and removes the links, so it's ready to be emailed out.
I'd also like to remove Module 1 if it's possible within the code.
Any takers?

Many Thanks

 

[GHolden]

Hi,

you can use:

Set vbComp = Application.VBE.ActiveVBProject.VBComponents
vbComp.Remove VBComponent:=vbComp.Item("Module1")

Depending on version of Office you may need to change trust settings.

Regards, Graham

There are two ways to write error-free programs; only the third one works.

 

[LGMan]

Thanks for the help, just had to google the trust bit and make the changes

 

[SkipVought]

Rather than saving your new presentation as a .pptm (macro enabled), save as a *.pptx.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}