Can you lock the column width?

  • Thread starter Thread starter Nightshade
  • Start date Start date
N

Nightshade

I would like to lock the column width, but still allow data to be entered in
the column. Is this possible?
 
--Select the range of cells in which the user needs to be allowed to enter
data. Right click>Protection tab>uncheck 'Locked
--From menu>Tools>Protection>Protect 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
 
--Select the range of cells in which the user needs to be allowed to enter
data. Right click>Protection tab>uncheck 'Locked
--From menu>Tools>Protection>Protect 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
Click to expand...

Thanks Jacob, that solved the issue!

--
*This message and any attachments is intended for the named addressee(s)
only and may contain information that is privileged and/or confidential. If
you receive this message in error, please delete it and immediately notify
the sender. Any copying, dissemination or disclosure, either whole or
partial, by a person who is not the named addressee is prohibited. We use
virus scanning software but disclaim any liability for viruses or other
devices which remain in this message or any attachments.
*******************************
Ce message, ainsi que toute piece jointe, est exclusivement adresse au(x)
destinataire(s) nomme(s) et peut contenir des informations confidentielles.
Si vous recevez ce message par erreur, merci de le detruire et d'en avertir
immediatement l'emetteur. Toute copie, transmission ou divulgation,
integrale ou partielle, par une personne qui n'est pas nommee comme
destinataire est interdite. Nous utilisons un logiciel anti-virus mais nous
denions toute responsabilite au cas ou des virus, ou tout autre procede,
seraient contenus dans ce message ou toute piece jointe.*
 
Pada Kamis, 22 Oktober 2009 0:18:03 UTC+7, Nightshade menulis:
I would like to lock the column width, but still allow data to be entered in
the column. Is this possible?
Click to expand...

thanx guys! verry helpful
 
--Select the range of cells in which the user needs to be allowed to enter
data. Right click>Protection tab>uncheck 'Locked
--From menu>Tools>Protection>Protect 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
Click to expand...


Thanks Jacob, you just saved me hours that would have been wasted on trial and error.
 
--Select the range of cells in which the user needs to be allowed to enter
data. Right click>Protection tab>uncheck 'Locked
--From menu>Tools>Protection>Protect 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
Click to expand...

This worked perfectly. Thanks bud!
 
Back
Top