Code to delete/remove code

Hi Stephen,

Thanks for your response. When I get a chance to rebuild the report I'll give it a go.

I did have a quick flick through various forums and came across some code. I have'nt tried it yet but wonder what you thought (pasted below). It makes sence to me but I'm resonably new to VBA. This would be run from a seperate module (Not "ThisWorkbook").

Sub DeleteWorkbookEventCode()

''Needs Reference Set To _

"Microsoft Visual Basic For Applications Extensibility"

'Tools>References.

With ThisWorkbook.VBProject.VBComponents("ThisWorkbook").CodeModule

.DeleteLines 1, .CountOfLines

End With

End Sub


Thanks

Matt