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.

Hi Swarnendu,

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.

Not really. It appears to be an overly-restrictive mail server, so try
zipping the file (www.winzip.com) and sending that instead.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

Also remember to check responses to the same post in
..office.developer.vba

--
Regards,

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

In article ,
says...
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.