Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a data entry edit mask? | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Data validation to prevent duplicate entry. | Excel Discussion (Misc queries) | |||
Formatting a worksheet for data entry | Excel Worksheet Functions | |||
help with macro to save repeating data entry | Excel Discussion (Misc queries) |