Password protect macro
 

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

Password protect macro
 

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

In VBA, use;

Worksheets("Sheet1").Protect "YourPasswordHere"


--
Olly


"Pete" wrote in message
...
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.

Password protect macro
 

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

On 4/15/04 13:27, in article , "Pete"
wrote:

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