Macro , Unprotect-Protect -- Atten: Tom Ogilvy

[Ed]

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

 

[Ron de Bruin]

Hi Ed

Look in the VBA help for Protect
You can use a password in your code

Worksheets("abc").Protect Password:="password"

 

[Tom Ogilvy]

Worksheets("abc").Unprotect Password:="ABCD"

Worksheets("abc").Protect Password:="ABCD"

 

[Ed]

Thanks Tom and Ron
Works Great.
Ed

-----Original Message-----
Worksheets("abc").Unprotect Password:="ABCD"

Worksheets("abc").Protect Password:="ABCD"

--
Regards,
Tom Ogilvy






.