I am creating a save as macro that is going to save sheet 1 and sheet 2 (with all data / formulates / etc) into a new workbook that will be named from info form a combobox and textbox. It is going to not only copy the code from both sheets 1,2 but also a macro created in the modules.

here is what I have so far:

Please Login or Register  to view this content.

Not sure if I need to separate the commands to different modules the call them from the save macro. Any assistance would be appreciated.