Thanks for that Tom - I've checked the settings and there seems to be
no hint of a transition default hijacking the code. I'm starting to
wonder if my Excel installation is corrupt in some way - I'm also
having trouble killing a custom toolbar despite erasing all the
personal.xls and .xlb files I could find! Will ask IT to re-install and
see if that helps


Tom Ogilvy wrote:
It could be that at some point the file is being saved in the Excel5/95
format. This format does not support Userforms or sheet module code and this
code and userforms are removed. I would see it being accidentially saved in
this format because of the default format setting in the Transformation tab
of tools = Options rather than some 3rd party program.

--
Regards,
Tom Ogilvy



"Pete" wrote:

Can anyone shed any light on why/how an Excel spreadsheet could
mysteriously "lose" the modules for both user forms and VBA? It seems
to be happening on emailing using Outlook, but the real mystery is that
it's intermittent - a spreadsheet sent one day will arrive without the
modules but if I re-send it then it will in all likelihood keep the
modules.

I have been told it might be 3rd party email safety software but if
that's true then why aren't all my spreadsheets stripped of the modules
when I send them?

Any hints gratefully accepted

Peter UK