Hi,

I'm wondering if it is possible to have a macro that would delete all macros
from the "ThisWorkbook" section when the workbook is saved?

The reason I ask is because I have a macro within the "ThisWorkbook" section
that does a few things automatically when the workbook is opened. However,
before the populated workbook is saved some of the worksheets that are
referenced in that opening macro are no longer there so the next time the
spreadsheet is opened I now get errors.

A long winded explaination but I just wanted to know if it was possible to
do it.

Thanks in advance.
Rob