Hi,
I have inserted macro to protect all of my sheets, and password for the
protection. but anybody can view code of my macro and take my password. what
is the solution for this insecurity.
--
Life isa journey not a destination

Sherees,

Additional to Micky's answer you should be aware that while the suggested
method will deter the honest anyone with Google and the desire to do so could
open your VB project quite easilly.

VB project protection is better than worksheet protection but is easilly
defeated.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sherees" wrote:

Hi,
I have inserted macro to protect all of my sheets, and password for the
protection. but anybody can view code of my macro and take my password. what
is the solution for this insecurity.
--
Life isa journey not a destination

Sherees wrote:
Hi,
I have inserted macro to protect all of my sheets, and password for the
protection. but anybody can view code of my macro and take my password. what
is the solution for this insecurity.

The real solution is expensive. You need an Excel compiler,
e.g.http://www.doneex.com/

You can Google for others.

Bill