Allowing Data Entry ONLY???

M

mthespike

Hello and thank you in advance for any assistance you may be able t
provide,

I have a spreadsheet in 03, which I want to give others the ability t
enter data into, but keep them from performing any other functions
such as cell formating, row/column insertion and deletion.

Using the protection and lock features seems to keep everything fro
being editable, but I cannot figure out how to do this, while allowin
the data itself to be edited.

Help??
 
K

Krizhek

From what you provided you should be able to select all the cells you want
them to have access to then go to format cells and under the protection tab
uncheck the 'Locked' box.

Then once you protect the sheet the should only be allowed to do data entry.
 
Top