Password protect macro

P

Pete

Does anyone have a good macro that I could use to protect
my worksheet against invasion that allows me to assign a
actual word to the protection. I know this is note the
safest thing in the world to do but that the best I can do
to protect my info.

Thanks
Pete
 
O

Olly

What is wrong with normal worksheet protection?? (e.g. Tools > Protection >
Protect Sheet)

In VBA, use;

Worksheets("Sheet1").Protect "YourPasswordHere"
 
T

TH

While in the macro editor goto TOOLS/VBA Project Properties. Click the
Protection tab. Check the box "Lock Project for Viewing". Enter a password
of at least 10 characters and use some letters and characters such as
p3te!s[]pa55@

The macro password protection is much more secure (Excel 2000 or later) than
sheet or workbook protection, but there are people out there guaranteeing to
break it...for a fee. The free stuff I have found to break passwords cannot
break the macro protection password. I'm also sure I haven't found all the
free password breakers.

TH
 
Top