Copying workbook with VBA
I have a workbbok that will be a "template" once it's finished. This workbook
runs macros to complete several sheets. Once this is done, I want the
program to save a new workbook, including a custom color palatte, custom page
margins and cell sizing. I DON'T want to macros to be saved in the new file.
Is there a way to do this?
|