Password protection in macro ( Anybody can view my password in VB

[Sherees]

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.

 

[Mike H]

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.

 

[Bill Sharpe]

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