Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a comment on cell content change with VBA
Hello all, i have a spreadsheet that is protected and shared. When the
user logs in it "unlocks" a certain range of cells for him to update. I would like to insert a comment when he/she updates the cell, but the worksheet "Change" function does not work if it is shared & protected. Is there a way around this ?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a comment on cell content change with VBA
The worksheet_change event should still fire.
I bet you're trying to unprotect the worksheet, add the comment (a real comment or just text in a different cell????), then reprotect the worksheet. If that's correct, then you've seen that you can't change the worksheet protection of a shared workbook. Les wrote: Hello all, i have a spreadsheet that is protected and shared. When the user logs in it "unlocks" a certain range of cells for him to update. I would like to insert a comment when he/she updates the cell, but the worksheet "Change" function does not work if it is shared & protected. Is there a way around this ?? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a comment on cell content change with VBA
Hi Dave, yes that is what i am trying to do. I am trying to put in the real comment as to who did the change. Is there a way to do this ?? On Feb 28, 4:37*pm, Dave Peterson wrote: The worksheet_change event should still fire. I bet you're trying to unprotect the worksheet, add the comment (a real comment or just text in a different cell????), then reprotect the worksheet. If that's correct, then you've seen that you can't change the worksheet protection of a shared workbook. Les wrote: Hello all, i have a spreadsheet that is protected and shared. When the user logs in it "unlocks" a certain range of cells for him to update. I would like to insert a comment when he/she updates the cell, but the worksheet "Change" function does not work if it is shared & protected. Is there a way around this ?? -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a comment on cell content change with VBA
You can protect the worksheet, but allow the user to edit objects (including
Comments and other objects). If you have pictures/buttons/comboboxes..., then these will be unprotected, too. In xl2003 menus: Unshare the workbook Unprotect the worksheet reprotect the worksheet: Tools|Protection|protect sheet, but check the "edit objects" under the Allow all users of this worksheet to" box. Share the workbook and test it out. Les wrote: Hi Dave, yes that is what i am trying to do. I am trying to put in the real comment as to who did the change. Is there a way to do this ?? On Feb 28, 4:37 pm, Dave Peterson wrote: The worksheet_change event should still fire. I bet you're trying to unprotect the worksheet, add the comment (a real comment or just text in a different cell????), then reprotect the worksheet. If that's correct, then you've seen that you can't change the worksheet protection of a shared workbook. Les wrote: Hello all, i have a spreadsheet that is protected and shared. When the user logs in it "unlocks" a certain range of cells for him to update. I would like to insert a comment when he/she updates the cell, but the worksheet "Change" function does not work if it is shared & protected. Is there a way around this ?? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a comment on cell content change with VBA
Thanks Dave, much appreciated.
On Feb 28, 6:46*pm, Dave Peterson wrote: You can protect the worksheet, but allow the user to edit objects (including Comments and other objects). *If you have pictures/buttons/comboboxes..., then these will be unprotected, too. In xl2003 menus: Unshare the workbook Unprotect the worksheet reprotect the worksheet: *Tools|Protection|protect sheet, but check the "edit objects" under the Allow all users of this worksheet to" box. Share the workbook and test it out. Les wrote: Hi Dave, yes that is what i am trying to do. I am trying to put in the real comment as to who did the change. Is there a way to do this ?? On Feb 28, 4:37 pm, Dave Peterson wrote: The worksheet_change event should still fire. I bet you're trying to unprotect the worksheet, add the comment (a real comment or just text in a different cell????), then reprotect the worksheet. If that's correct, then you've seen that you can't change the worksheet protection of a shared workbook. Les wrote: Hello all, i have a spreadsheet that is protected and shared. When the user logs in it "unlocks" a certain range of cells for him to update.. I would like to insert a comment when he/she updates the cell, but the worksheet "Change" function does not work if it is shared & protected. Is there a way around this ?? -- Dave Peterson -- Dave Peterson- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert From Comment to Cell Content | Excel Discussion (Misc queries) | |||
Converting cell content into comment | Excel Programming | |||
Converting cell content into comment | Excel Discussion (Misc queries) | |||
Converting cell content into comment | Excel Discussion (Misc queries) | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) |