Guys,

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?

Any ideas?

Without testing it and of the top of my head when you have finished formatting and saving your spreadsheet. Why not create have another spreadsheet that opens up the previous spreadsheet and deletes the macro and then save the spreadsheet.

Just a thought:confused: