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.