View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
phoenix[_2_] phoenix[_2_] is offline
external usenet poster
 
Posts: 2
Default Allowing editing locked cells in a protected sheet in excel

Hi,

1. I have an protected excel sheet in which Columns A,B,C are locked and
cannot be editted by everyone however columns D and E are open to be edited
by everyone.
2. However my problem is when I click on protect worksheet and add myself in
the permissions tab to edit without password, I cannot edit and the whole
sheet gets locked. This is not expected.

Please help