VBA code disappearing from Project

L

Lenny

VBA code entered in a module (new macros) disappears or is stripped out when
emailing between users. The code is there before being emailed and is there
upon first opening (user gets Security warning to either disable or enable)
macros. User Enables Macros allowing them to run when called... After
closing and resending the file back, no security warning and all code is
'gone' from the module. Doesn't seem to happen every time or every instance.
I believe our default Word Security Setting in the company is 'High'.

Does anyone know what might be happening so I can correct?

Desperately Seeking Solution!
 
J

Jay Freedman

Word doesn't remove code, regardless of the security setting. All it does on
the High setting is prevent any code from running.

I'll guess that whatever antivirus code runs on either the mail server or
some of the workstations is doing the damage. For that reason and many
others, it's a good idea to zip Word documents before mailing them. WinZip
and some other utilities can add a right-click menu item to Windows Explorer
to "zip and mail" in one step.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
L

Lenny

Jay: my thanks for the information... I now have a starting spot to correct
the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top