Remove Macros from a workbook with VBA

[rsilberfarb]

Hello All,

I have a master file that I use to generate an Excel based user form. The master document has several macros in it that do not need to be in the user form. I generate the form by saving the file as a different name, but all the macros transfer to the user form. One macro in particular is in the workbook open sub, so it runs when the workbook is open.

I need to be able to disable that one line in the workbook open sub (I have antoher line of code in there that creates a custom toolbar) .

Thanks in advance

Ross

[Bob Phillips]

If you know the line number of the ofending line, you can remove it with

ThisWorkbook.VBProject.VBComponents("ThisWorkbook").codemodule.DeleteLines 5, 1

where 5 is the line number

[rsilberfarb]

Not only did that work, but you guessed the right line to delete.

Thanks!!!!!!!!!!

Ross

[Bob Phillips]

Not only did that work, but you guessed the right line to delete.

You must write the same code as me

[Zack Barresse]

Not only did that work, but you guessed the right line to delete.

I think xld reads minds.