--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
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.*
