Locking column

  • Thread starter Thread starter LSB
  • Start date Start date
L

LSB

Can anybody tell me how too lock a column, where by i do
not want to allow user to update that column.?
 
Hi LSB!

By implication, I take it that the rest of the sheet is not locked.

Select the entire sheet by clicking the button at the intersection of
rows and columns headings (or Ctrl + A)
Format > Cells
Protection Tab
Remove check from Locked
OK

Select the column that you want to lock by clicking it's column letter
Format > Cells
Protection Tab
Place check in Locked
OK

Tools > Protection > Protect Sheet
Give and confirm passwords if you want
OK

But note that Excel worksheet security is not really designed to do
more than protect against accidental changing of formulas as security
is easily circumvented.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Sunday 27th July: Cuba (Revolution Day),
Djibouti (Independence Day), Hong Kong (Lu Pan Day), North Korea
(Victory Day), Puerto Rico (Barbosa Day), Russian Federation (Navy
Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top