Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent "delete" only
On a specific worksheet, I would like to prevent users from "deleting"
anything, e.g., rows, columns, or cells. They should be able to clear data but just not delete. Is it possible to prevent users from deleting on a specific sheet? Thanks. -- JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent "delete" only
Maybe you can unlock the cells and then protect the worksheet.
Format|Cells|protection tab (to toggle the lockedness of the cells) Tools|protection|protect worksheet (to protect the worksheet). Remember that worksheet protection isn't very robust. It won't stop anyone who really wants to make these changes. JT wrote: On a specific worksheet, I would like to prevent users from "deleting" anything, e.g., rows, columns, or cells. They should be able to clear data but just not delete. Is it possible to prevent users from deleting on a specific sheet? Thanks. -- JT -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |