Protecting macros

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
 
C

Chip Pearson

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
 
D

Dan E

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...
 
D

Dan E

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...
 
D

Dan E

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...
 
Top