Did not work,

This still creates a saved file that has no Sheet1 worksheet, bu
maintains its module as a VBE object. I know for a fact that th
procedure does delete the module, but only at the end of the macro. Th
module disappears from the VBE, but the file had already being saved. I
I save a second time, the module is then gone in the saved file, but
don't want to ask the user to save twice

--
pherreroPosted from http://www.pcreview.co.uk/ newsgroup acces