Hi there,

I have a excel workbook with single sheet and want to
save. The problem is that there are a couple of forms in
workbook_open event. If I use workbook.Saveas method to
save the book, those forms will pop up when I open saved
files. What is the best way to save workbook without
saving the code? Or what is the best way to
programatically delete the code and save? I copied the
book to a new book and save the new book by using
Workbook.SaveAs FileName:= "Name", FileFormat:=
xlExcel4, "", "", "", I also able to save the book without
the code. But the problem is that those forms poped up
twice during copy book and reactive original book since I
need to bring original book back for upcoming process.
Thank you very much in advance for help.

Hugh