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

S

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.
 
M

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.
 
B

Bill Sharpe

Sherees said:
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
 

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