Hi Paul
You can run a macro that delete the whole module where
you store the macro's.
The macro you run is also in this module
Sub deletemodule()
With ThisWorkbook.VBProject.VBComponents
.Remove .Item("Module1")
End With
End Sub
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Paul_Russell " wrote in message ...
I run a report every morning and have written some code to save the
report with today's date.
However every file that has been saved contains all the macros that
were in the template.
Is there an easy way to save files without saving the macros?
Cheers
Paul
---
Message posted from http://www.ExcelForum.com/