| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect contents in a cell from deletion
I need to protect the content of a particular cell from
being deleted but I do not want to protect the whole spreadsheet since some of the data in it needs to be altered on daily basis. Any ideas? Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nevermind
I figured out what was confusing me. In my excel
application all cells are locked by default. So when I choose a particular cell and lock it and then protect the workbook all of the cells are locked. So I had to unlock the whole workbook and then lock all the cells I need to... I can't believe I didn't figure this out earlier... -----Original Message----- I need to protect the content of a particular cell from being deleted but I do not want to protect the whole spreadsheet since some of the data in it needs to be altered on daily basis. Any ideas? Thank you! . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nevermind
Could you please tell me how you did that? I need to lock
the column headings so noone can change the label when entering into a form . Thanks for any input. I was having the same problem. -----Original Message----- I figured out what was confusing me. In my excel application all cells are locked by default. So when I choose a particular cell and lock it and then protect the workbook all of the cells are locked. So I had to unlock the whole workbook and then lock all the cells I need to... I can't believe I didn't figure this out earlier... -----Original Message----- I need to protect the content of a particular cell from being deleted but I do not want to protect the whole spreadsheet since some of the data in it needs to be altered on daily basis. Any ideas? Thank you! . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nevermind
I hope this would help out:
First I would select the whole sheet and then go to FORMAT, CELLS, PROTECTION and unselect Locked and Hidden. Then, Select the cells that you would like to lock for editting and repead the same step as above but this time choose Locked. Then go to TOOLS, PROTECTION, Protect Sheet. There is another way I would lock the cells. If they are text (as in your case) then I would use the validation option and specify some weird numbered range, and this way no one can really change them. ( I used DATA, VALIDATION, NUmber range)... -----Original Message----- Could you please tell me how you did that? I need to lock the column headings so noone can change the label when entering into a form . Thanks for any input. I was having the same problem. -----Original Message----- I figured out what was confusing me. In my excel application all cells are locked by default. So when I choose a particular cell and lock it and then protect the workbook all of the cells are locked. So I had to unlock the whole workbook and then lock all the cells I need to... I can't believe I didn't figure this out earlier... -----Original Message----- I need to protect the content of a particular cell from being deleted but I do not want to protect the whole spreadsheet since some of the data in it needs to be altered on daily basis. Any ideas? Thank you! . . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nevermind
There is a more sofisticated way, see also my reply to
the posted item above (Run Macro when contents of cell change). If you use the example code I put there and where it says ' put your code here ... put Range("xx").Select (make sure xx refers to the next cell in the tab-order), then whenever the cell you want to protect (in this example A1) is selected the macro will select the next cell. Impossible to select the cell and change it like that. -----Original Message----- I hope this would help out: First I would select the whole sheet and then go to FORMAT, CELLS, PROTECTION and unselect Locked and Hidden. Then, Select the cells that you would like to lock for editting and repead the same step as above but this time choose Locked. Then go to TOOLS, PROTECTION, Protect Sheet. There is another way I would lock the cells. If they are text (as in your case) then I would use the validation option and specify some weird numbered range, and this way no one can really change them. ( I used DATA, VALIDATION, NUmber range)... -----Original Message----- Could you please tell me how you did that? I need to lock the column headings so noone can change the label when entering into a form . Thanks for any input. I was having the same problem. -----Original Message----- I figured out what was confusing me. In my excel application all cells are locked by default. So when I choose a particular cell and lock it and then protect the workbook all of the cells are locked. So I had to unlock the whole workbook and then lock all the cells I need to... I can't believe I didn't figure this out earlier... -----Original Message----- I need to protect the content of a particular cell from being deleted but I do not want to protect the whole spreadsheet since some of the data in it needs to be altered on daily basis. Any ideas? Thank you! . . . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nevermind
As in
Normally the default value is for the cell to be locked. -- Regards, Tom Ogilvy Diana wrote in message ... I figured out what was confusing me. In my excel application all cells are locked by default. So when I choose a particular cell and lock it and then protect the workbook all of the cells are locked. So I had to unlock the whole workbook and then lock all the cells I need to... I can't believe I didn't figure this out earlier... -----Original Message----- I need to protect the content of a particular cell from being deleted but I do not want to protect the whole spreadsheet since some of the data in it needs to be altered on daily basis. Any ideas? Thank you! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect a Cell - Only insert should be possible, not deletion | Excel Discussion (Misc queries) | |||
| protect worksheet but allow row deletion | Excel Worksheet Functions | |||
| Conditional deletion of cell contents | Excel Worksheet Functions | |||
| protect a file from deletion | Excel Discussion (Misc queries) | |||
| protect formula in cell and still allow data deletion | Excel Discussion (Misc queries) | |||
![Diana[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
