View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amarie
 
Posts: n/a
Default How do I lock a column in EXCEL to prevent changes-can add input

I have been struggling with this problem.

I have created a form in Excel that will be used by many people. I have to
be able to lock 3 columns in the form so that no one but me and 1 other
person can change the verbiage in these 3 columns.

The rest of the columns in the document needs to be accessible to enter
numbers next to the locked columns.

Any assistance would be appreciated!!!!!!

Thanks!

Aimee