View Single Post
  #2   Report Post  
Old October 21st 09, 06:24 PM posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,520
Default Can you lock the column width?

--Select the range of cells in which the user needs to be allowed to enter
data. Right clickProtection tabuncheck 'Locked
--From menuToolsProtectionProtect sheet. From the list allow everything
except 'format columns' and 'format rows'
--Hit OK (If you need you can assign a password..)

If this post helps click Yes
Jacob Skaria

"Nightshade" wrote:

I would like to lock the column width, but still allow data to be entered in
the column. Is this possible?