Enabling Excel Macros Over Mails

[Swarnendu Banerjee]

I have written some Excel Macros to customize my
Worksheet. the problem I am facing is that whenever I am
mailing this Worksheet to others the Macros are
getting "Cleaned and Quarantined" , thus leading to the
very objective of my code to be a total failure.

I presume that this is a problem of the Mail server which
disables all macros, but Is there any way, by which a
Macro can be denotd as "safe" or something like that so
that it can be send over mails safely to other people.

Early reply would be highly entertained.

 

[Tushar Mehta]

If you could do what you want, so could every virus writer!

That said, most organizations have taken server-level steps to stop
potentially dangerous mail since too many employees in too many
organizations have merrily opened emails containing viruses that led to
globally-recognized virus attacks.

You can do any number of things. Zip your file with WinZip or a
competing product. Have the recipient unzip the file then open the XL
workbook. Better yet, put your macros in an add-in. Even better,
create a signed add-in. For more see http://groups.google.com/groups?
selm=MPG.1901cfa02bf8ad7498aaa3%40msnews.microsoft.com

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Tushar Mehta]

Also remember to check the responses to the same post in
..excel.programming.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions