View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.misc
[email protected] atexbaco@gmail.com is offline
external usenet poster
 
Posts: 1
Default Can you lock the column width?

Hi Jacob, I need to protect the size of the rows and columns in order to have no one change the width and height of rows and columns;
Is there any way to do this?
Thanks!


On Wednesday, October 21, 2009 at 2:24:01 PM UTC-3, Jacob Skaria wrote:
--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?