Password Protect Macro?

G

Guest

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
 
C

Chip Pearson

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


message
news:[email protected]...
 
G

Guest

Thank you very much Chip.

Ryan Hess

Chip Pearson said:
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


message
Click to expand...
 
G

Guest

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

Tom Ogilvy

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.
 

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

Similar Threads

How to Unlock Excel Workbook protected by MACRO Password 6
not able to enable macro in password protected .xlsm workbook. 2
Novice - using macro to protect with password 10
including macro in protected worksheet 2
Removing pasword-protected macro 4
Macros and Password Protection 6
Knowing is a workbook's VBA project has password or not 2
Open password protected file with macros 2

Top