Copy/Save As xlsm workbook to new xlsm workbook is not copying the code with it

Your code is much more complicated than what is necessary. It is unnecessary to create a new workbook and then copy content. You just need to save the existing workbook with a new name, and it continues to be the active workbook. I have tested this.

Please Login or Register  to view this content.

However, I am still concerned about your overall approach. You said that you want the macros to stay intact. As a consequence, the next time it's opened it's going to make another 2nd generation copy of itself. For example, when the user opens "Purchase Request.xlsm" it is saved as "2013-08-01 20-25-00 Purchase Request.xlsm". If someone opens that second file it's going to be saved as "2013-08-01 21-34-00 2013-08-01 20-25-00 Purchase Request.xlsm". Therefore nobody can ever edit the original file!

I think you still have a problem with your Submit Changes button, because it refers to a macro in the original file. I think you may want to use an ActiveX control that will call a macro in the file that contains it. Here is your file >Purchase Request.xlsm< with my updated code plus an alternative for your button.

By the way here is what I see >Grinchy_nocode.jpg< when I try to look for code in the file you attached.

I just realized why I don't see your code. When I open your file, I enable macros and of course, it makes a copy of itself. Without the code. Which was your original problem. My bad.

I think everything is working the way I want with the exception that you pointed out about the 2nd generation copy. Is there a way to say in the code you provided, that "If" the file is titled "Purchase Request.xlsm" then perform this action?