Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection
Is there a way to once data is entered and saved, the user cannot go back to
that range and make edits even though there may be a blank row between to completed rows? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection
my sugestion is:
click on the row # below you entered data ( the whole row should be highlighted ) for example if your data entry comes up till row 100 you should highlight the row 101 hit end key and the hold shift and hit down arrow key ( all rows in the sheet should be highlighted except the area you entered your data ) right click on the highlighted area and choos format cells and then go to protection tab and uncheck the locked checkbox go to: ToolsProtectionprotect sheet and creat a password and then click ok every time you entered new data you have to unprotect your sheet and just highlight your data area and right click on them and choos format cells and go to protection tab and make the locked check box checked and then protect your sheet again. Thanks, -- Farhad Hodjat "JessicaMWA" wrote: Is there a way to once data is entered and saved, the user cannot go back to that range and make edits even though there may be a blank row between to completed rows? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Protection | Excel Worksheet Functions | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Protection | Excel Discussion (Misc queries) | |||
Another Protection Q | Excel Discussion (Misc queries) |