Is it possible to password protect a macro so that no one is able to go into
your macro and modify it without a password?

Thank you,
Ryan Hess

Yes, it is possible, but VBA passwords can be cracked using
software readily available on the net. To protect a project, open
the VBA Editor, go to the Tools menu, choose VBA Project
Properties, then the Protection tab. There, check the "Lock
Project For Viewing" option and supply a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ryanmhess" wrote in
message
...
Is it possible to password protect a macro so that no one is
able to go into
your macro and modify it without a password?

Thank you,
Ryan Hess

Thank you very much Chip.

Ryan Hess

"Chip Pearson" wrote:

Yes, it is possible, but VBA passwords can be cracked using
software readily available on the net. To protect a project, open
the VBA Editor, go to the Tools menu, choose VBA Project
Properties, then the Protection tab. There, check the "Lock
Project For Viewing" option and supply a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ryanmhess" wrote in
message
...
Is it possible to password protect a macro so that no one is
able to go into
your macro and modify it without a password?

Thank you,
Ryan Hess

Are there any other options? I want to distribute spreadsheets with a Visual
Basic macro but deny the user access to the macro.

"Chip Pearson" wrote:

Yes, it is possible, but VBA passwords can be cracked using
software readily available on the net. To protect a project, open
the VBA Editor, go to the Tools menu, choose VBA Project
Properties, then the Protection tab. There, check the "Lock
Project For Viewing" option and supply a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ryanmhess" wrote in
message
...
Is it possible to password protect a macro so that no one is
able to go into
your macro and modify it without a password?

Thank you,
Ryan Hess

Chip has described the method.

The only other option is to build the majority of your code in VB6 and
compile it to a DLL or build a standalone application.

--
Regards,
Tom Ogilvy

"Noel Rietman" <Noel wrote in message
...
Are there any other options? I want to distribute spreadsheets with a
Visual
Basic macro but deny the user access to the macro.

"Chip Pearson" wrote:

Yes, it is possible, but VBA passwords can be cracked using
software readily available on the net. To protect a project, open
the VBA Editor, go to the Tools menu, choose VBA Project
Properties, then the Protection tab. There, check the "Lock
Project For Viewing" option and supply a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ryanmhess" wrote in
message
...
Is it possible to password protect a macro so that no one is
able to go into
your macro and modify it without a password?

Thank you,
Ryan Hess