Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect data in a cell, but allow comments to be entered.
Hi All,
I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla within them cannot be edited/removed, however, I would like all users to be able to insert comments in these fields. The edit objects selection when protecting the sheet allows for comment entry, but it also allows the user to alter the data in the cell. Any solutions/ advise on this would be greatly appreciated. Many Thanks Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect data in a cell, but allow comments to be entered.
Sheet is not protected.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Application.EnableEvents = False Application.Undo Application.EnableEvents = True End If End Sub http://cjoint.com/?ennkKYJTmT JB http://boisgontierjacques.free.fr/ On 13 avr, 12:26, Chris wrote: Hi All, * * * * *I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla within them cannot be edited/removed, however, I would like all users to be able to insert comments in these fields. The edit objects selection when protecting the sheet allows for comment entry, but it also allows the user to alter the data in the cell. Any solutions/ advise on this would be greatly appreciated. Many Thanks Chris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect data in a cell, but allow comments to be entered
Hi JB,
Many thanks for your reply. Could I possibly trouble you to ask how this works?, or what it does exactley? Is there something specific I need to do one I place this into VB for the worksheet? Apologies for the vagueness of the question, I just dont fully understand it, Im greatly appreciative of your response. "JB" wrote: Sheet is not protected. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Application.EnableEvents = False Application.Undo Application.EnableEvents = True End If End Sub http://cjoint.com/?ennkKYJTmT JB http://boisgontierjacques.free.fr/ On 13 avr, 12:26, Chris wrote: Hi All, I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla within them cannot be edited/removed, however, I would like all users to be able to insert comments in these fields. The edit objects selection when protecting the sheet allows for comment entry, but it also allows the user to alter the data in the cell. Any solutions/ advise on this would be greatly appreciated. Many Thanks Chris . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect data in a cell, but allow comments to be entered.
When I tested this in xl2003, I locked the cell, and protected the worksheet --
but allowed the user to edit objects. I could insert comments, but I was still stopped when I tried to change the value/formula in the locked cell. Maybe it's time to test again -- or share what version of excel you're using. Chris wrote: Hi All, I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla within them cannot be edited/removed, however, I would like all users to be able to insert comments in these fields. The edit objects selection when protecting the sheet allows for comment entry, but it also allows the user to alter the data in the cell. Any solutions/ advise on this would be greatly appreciated. Many Thanks Chris -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect data in a cell, but allow comments to be entered
Hi JB,
Please ignore the last message, Ive tried, and it works :) Thanks so much, very much appreciated. Thanks "Chris" wrote: Hi JB, Many thanks for your reply. Could I possibly trouble you to ask how this works?, or what it does exactley? Is there something specific I need to do one I place this into VB for the worksheet? Apologies for the vagueness of the question, I just dont fully understand it, Im greatly appreciative of your response. "JB" wrote: Sheet is not protected. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Application.EnableEvents = False Application.Undo Application.EnableEvents = True End If End Sub http://cjoint.com/?ennkKYJTmT JB http://boisgontierjacques.free.fr/ On 13 avr, 12:26, Chris wrote: Hi All, I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla within them cannot be edited/removed, however, I would like all users to be able to insert comments in these fields. The edit objects selection when protecting the sheet allows for comment entry, but it also allows the user to alter the data in the cell. Any solutions/ advise on this would be greatly appreciated. Many Thanks Chris . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect data in a cell, but allow comments to be entered
Hi Dave,
Thats precisely what it was I needed to achieve on this particular occasion. I am using 2007, the problem I was initially faced with was that when I protected the sheet and enabled edit objects, users could enter comments, but could also delete the formula in the cells, which is what I didnt want them to do. I wanted them to be able to insert comments, but not alter the cell data. Perhaps Im mis-understanding what it is youre saying, but from what I gather, what you will want to do is, do exactley what youre doing, but without the VBA code, in saying that though, we are using different excel versions, so perhaps its different in 2003-2007. I hope I havent confused the matter :) "Dave Peterson" wrote: When I tested this in xl2003, I locked the cell, and protected the worksheet -- but allowed the user to edit objects. I could insert comments, but I was still stopped when I tried to change the value/formula in the locked cell. Maybe it's time to test again -- or share what version of excel you're using. Chris wrote: Hi All, I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla within them cannot be edited/removed, however, I would like all users to be able to insert comments in these fields. The edit objects selection when protecting the sheet allows for comment entry, but it also allows the user to alter the data in the cell. Any solutions/ advise on this would be greatly appreciated. Many Thanks Chris -- Dave Peterson . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect data in a cell, but allow comments to be entered
It sounds like you either didn't lock the cells.
Rightclick on one|format cells|protection tab|and check locked. Or you didn't protect the sheet the way you wanted to (allowing them to edit objects). I just tested on xl2007 and when I did both of those, it worked exactly like you wanted. Chris wrote: Hi Dave, Thats precisely what it was I needed to achieve on this particular occasion. I am using 2007, the problem I was initially faced with was that when I protected the sheet and enabled edit objects, users could enter comments, but could also delete the formula in the cells, which is what I didnt want them to do. I wanted them to be able to insert comments, but not alter the cell data. Perhaps Im mis-understanding what it is youre saying, but from what I gather, what you will want to do is, do exactley what youre doing, but without the VBA code, in saying that though, we are using different excel versions, so perhaps its different in 2003-2007. I hope I havent confused the matter :) "Dave Peterson" wrote: When I tested this in xl2003, I locked the cell, and protected the worksheet -- but allowed the user to edit objects. I could insert comments, but I was still stopped when I tried to change the value/formula in the locked cell. Maybe it's time to test again -- or share what version of excel you're using. Chris wrote: Hi All, I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla within them cannot be edited/removed, however, I would like all users to be able to insert comments in these fields. The edit objects selection when protecting the sheet allows for comment entry, but it also allows the user to alter the data in the cell. Any solutions/ advise on this would be greatly appreciated. Many Thanks Chris -- Dave Peterson . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protect cells but allow to enter data but not remove once entered | Excel Discussion (Misc queries) | |||
protect cells only after information is entered | Excel Discussion (Misc queries) | |||
How do I lock unclock cells to protect the data entered? | Excel Worksheet Functions | |||
Protect data in cells after entered | Excel Discussion (Misc queries) | |||
Excel 97 Protect but allow comments | Excel Discussion (Misc queries) |