View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SueJB SueJB is offline
external usenet poster
 
Posts: 38
Default Unprotect column

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