See Chip Pearson's page on using code to manage the VBE.
http://www.cpearson.com/excel/vbe.htm


--
Regards,
Tom Ogilvy

"Paige" wrote in message
...
I am building a file that when opened it begins a series of userforms for
selection by the user. Once completed I have it so it automatically
deletes
all the modules & userforms in visual basics and saves the file as a
different name. Is there a way to delete the Workbook_Open code so that
the
next time I open the new file no macros are prompted?

Thank you for any help.