That's great - and SO simple - why didn't I think of that?

Many thanks for such a quick response

Sue

"gocush" wrote:

Try something like:


If logon User = xxx then
Activesheet.unprotect Password:="Hello"
Range("C:C").Locked=False
Activesheet.Protect Password:="Hello"
End if

Then in the wbk_BeforeClose event, reverse this to lock your col C


"SueJB" wrote:

Hi all

I have a worksheet that is either unprotected (to allow editing) or
protected (to allow viewing only) depending on a user login and password.
However, unprotection allows access to the entire sheet and now I need to
permit one user to edit one column only.

Is there a way to unprotect a single column in an otherwise protected
worksheet?

Thanks in advance!
SB