Deleting a Macro when document is saved as
I have another problem..
I have written a comprehensive Macro to format a spreadsheet and save it as another name in another folder.
My problem is that when the code actions the save as it also copies the Macro to the new document as well, and I do not want this to happen.
So my question is how can I code in VB to delete the Macro from the newly named workbook?
As you slide down the banister of life, may the splinters never point the wrong way.