Unprotect in a macro

[Partly Void]

The macro will run on a password protected sheet with Unprotect
Password:"123" but the actual password is clearly available to the user. Is
there a way to hide the password?

 

[Mike H]

Hi,

You can lock you VB project for viewing and this will give a measure of
security but anyone with a small amount of experience would still be able to
look at your code.

Excel protection is really only to reduce the risk of inadvertant or
accidental change and provides only minimal security.

The correct syntax is password:="123"


Mike

 

[Dave Peterson]

You can protect the code in your project.

Inside the VBE
tools|VBAProject Properties|Protection tab
Give it a nice, memorable password and check the lock project for viewing box.

Save and close your workbook and you'll see that the code can't be seen by the
average user.

Be aware that there are ways to break this protection--as well as ways to just
unprotect worksheets. So don't assume your data is safe from prying eyes.

 

[John G]

Dave,

I am working on a project that someone else started and locked the vb code
for an excel macro. How do I unlock the vba macro password?

Thanks,

John

 

[Dave Peterson]

Ask the original developer for the password.

Dave,

I am working on a project that someone else started and locked the vb code
for an excel macro. How do I unlock the vba macro password?

Thanks,

John