Allowing Data Entry ONLY???
 

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

I have a spreadsheet in 03, which I want to give others the ability to
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 from
being editable, but I cannot figure out how to do this, while allowing
the data itself to be edited.

Help???


--
mthespike
------------------------------------------------------------------------
mthespike's Profile: http://www.excelforum.com/member.php...o&userid=24751
View this thread: http://www.excelforum.com/showthread...hreadid=383222

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.

"mthespike" wrote:


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

I have a spreadsheet in 03, which I want to give others the ability to
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 from
being editable, but I cannot figure out how to do this, while allowing
the data itself to be edited.

Help???


--
mthespike
------------------------------------------------------------------------
mthespike's Profile: http://www.excelforum.com/member.php...o&userid=24751
View this thread: http://www.excelforum.com/showthread...hreadid=383222