Password Protect Macro?

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" <ryanmhess@discussions.microsoft.com> wrote in
message
news:F5EDFFE1-0D87-4A28-BC16-368F1E2F72A0@microsoft.com...
> 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" <ryanmhess@discussions.microsoft.com> wrote in
> message
> news:F5EDFFE1-0D87-4A28-BC16-368F1E2F72A0@microsoft.com...
> > 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" <ryanmhess@discussions.microsoft.com> wrote in
> message
> news:F5EDFFE1-0D87-4A28-BC16-368F1E2F72A0@microsoft.com...
> > 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 Rietman@discussions.microsoft.com> wrote in message
news:B83B944E-A0A0-40F5-A71D-6A5197756547@microsoft.com...
> 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" <ryanmhess@discussions.microsoft.com> wrote in
> > message
> > news:F5EDFFE1-0D87-4A28-BC16-368F1E2F72A0@microsoft.com...
> > > 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
> >
> >
> >