Protecting macros

  • Thread starter Thread starter Dan E
  • Start date Start date
D

Dan E

I need to password protect macros attached to a workbook - not the same as
protecting the sheets. All help gratefully received.
TIA,

Dan
 
In the VBA Editor, go to the Tools menu, choose VBA Project
Properties, then the Protection tab. Check the Lock Project For
Viewing option and enter a password.

Note that the password protection is not very secure. There are a
variety of programs on the net that can break the password in a
matter of seconds.


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

Dan
Chip Pearson said:
In the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab. Check the Lock Project For Viewing option and
enter a password.

Note that the password protection is not very secure. There are a variety
of programs on the net that can break the password in a matter of seconds.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Chip - that protection doesn't appear to work the way I want it to. I
applied a protection password as in your message to VBAProject (which
contains all the workbooks that have the macros attached that I want to
protect), closed down VBE, closed Excel, (after saving), reopened Excel,
loaded one of the workbooks, clicked Tools|Macros etc., and the VBE editor
opened, with all the macros there and editable. Am I being thick, and
missing something?

TIA,

Dan
Chip Pearson said:
In the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab. Check the Lock Project For Viewing option and
enter a password.

Note that the password protection is not very secure. There are a variety
of programs on the net that can break the password in a matter of seconds.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Not sure what I did, but that protection now appears to be working....

Thanks again,

Dan

Chip Pearson said:
In the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab. Check the Lock Project For Viewing option and
enter a password.

Note that the password protection is not very secure. There are a variety
of programs on the net that can break the password in a matter of seconds.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Back
Top