Hi
Is there a way to have code deleted once a certain command button is pressed.

Once this button has been clicked certain VBA code is no longer required so
I would like to have the code deleted.

The reason for this when the form is complete it needs to be emailed however
we have a limit for the size which can be emailed through our system.

At the moment the file is more the 2KB so if I could delete the code which
is no longer required the form will be able to be sent.

In have the code mostly in modules except for the Click functions and have a
few userforms.

Any suggestions woudl be greatly appreciated.

thanks
Noemi