Hi Tom
Thankyou for your help on this yesterday.
I put the following in my macro:

(at the start) Worksheets("abc").Unprotect

(at the end) Worksheets("abc").Protect

Basicly this works fine with one major problem.
You can't protect the sheet with a password.
If you do, you have to enter the password befor you can
run the macro. Then the password protection is gone.

What I need is this. After the above macro is run, I
need not only the sheet to be protected but still be
protected with a password. So that only the person that
knows the password can change a cell. That person being me.

Can this be done?
Thankyou
Ed