Unprotect in a macro
 

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?

Unprotect in a macro
 

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

"Partly Void" wrote:

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?

Unprotect in a macro
 

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.

Partly Void wrote:

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?

--

Dave Peterson

Unprotect in a macro
 

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" wrote:

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.

Partly Void wrote:

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?

--

Dave Peterson

Unprotect in a macro
 

Ask the original developer for the password.


John G wrote:

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" wrote:

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.

Partly Void wrote:

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?

--

Dave Peterson


--

Dave Peterson