Hi Paige;

You could try using an Auto_Open macro instead of the
workbook object or changing the code in either case to
reading the workbook name and then skipping all the
routines if it is not the original name. It might look
something like this;

Sub try()

If activeworkbook.name = "TheOrigianlName.xls" then

'do the stuff

End If


End Sub

Thanks,

Greg



-----Original 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.
.