Macro to delete a macro?

[robfo0]

Hi again,

I have a macro which I want to run one time, then delete it with code.

I was thinking have 2 macros, then when the one i want to delete runs, at the end ill add "Call deletemacro" which will call the 2nd macro to delete the first.

Does anyone have the code to delete a module of code from within vb?

Thanks

 

[Al Chara]

Take a look at Chip's page here:
http://www.cpearson.com/excel/vbe.htm

 

[robfo0]

Hi al,
Thanks for the link, i added the reference and tried this code:
Sub Delete_Save()
Dim VBComp As VBComponent
Set VBComp = ThisWorkbook.VBProject.VBComponents("SaveMacro")
ThisWorkbook.VBProject.VBComponents.Remove VBComp
End Sub

but im getting the error "Programmic access to Visual Basic Project is not trusted".

is there a way to get around this?

thanks

 

[MrExcel]

Yes. In tools > Macro > security, you can change this. Go to Trusted Sources tab and check the box for Trust Access to Visual Basic Project.