View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Protecting a single column

Only indirectly but you could try:-

Select all the cells on a worksheet and then format|cells|protection and
remove the locked check mark.

Then select the single column you want to hide and repeat the above but this
time check the locked box.

With your column still selected right click and hide the column and then
protect the worksheet. Users cannot now unhide you column and in effect it
isn't protected because all users cells are unlocked.

One warning, Excel protection is pretty useless so anyone with even
rudimentary knowledge could crack this security.

Mike

"Metallocene" wrote:

Is it possible, within an Excel spreadsheet that is not otherwise protected,
to hide and password-protect a single column of data? I want to have a
spreadsheet with data that is shared with co-workers, but within that
spreadsheet I want to have a column (or several columns) of data that only I
can view.

Thanks,