Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add comment in a protected sheet, Excel 2000
Hi everybody,
In Excel 2003 a user can add comment in a protected sheet, if editing objects is allowed. I have to make it possible also in Excel 2000 with VBA code. I´m thinking of using a userform with textbox but maybe there is some better way. Thanks in advance for any suggestion. Best Regards Mats -- ESI Update |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add comment in a protected sheet, Excel 2000
Mats,
You would need to give the user some userform/inputbox to enter their comment, .Unprotect the sheet, add/edit the comment in which cell, .Protect the sheet. NickHk "Mats Nilsson" ... Hi everybody, In Excel 2003 a user can add comment in a protected sheet, if editing objects is allowed. I have to make it possible also in Excel 2000 with VBA code. I¡¦m thinking of using a userform with textbox but maybe there is some better way. Thanks in advance for any suggestion. Best Regards Mats -- ESI Update |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add comment in a protected sheet, Excel 2000
Hi Nick,
Thanks for answer . I have just made a simple test with a userform and textbox to add comment so it will work. But there could be a comment in the cell already and in that case I have to load the textbox with the comment and then edit the comment. Regards Mats -- ESI Update "NickHK" wrote: Mats, You would need to give the user some userform/inputbox to enter their comment, .Unprotect the sheet, add/edit the comment in which cell, .Protect the sheet. NickHk "Mats Nilsson" ... Hi everybody, In Excel 2003 a user can add comment in a protected sheet, if editing objects is allowed. I have to make it possible also in Excel 2000 with VBA code. I¡¦m thinking of using a userform with textbox but maybe there is some better way. Thanks in advance for any suggestion. Best Regards Mats -- ESI Update |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add comment in a protected sheet, Excel 2000
if activecell.Coment is nothing then
' add comment else s = ActiveCell.Comment.Text ' edit comment End if -- Regards, Tom Ogilvy "Mats Nilsson" wrote: Hi Nick, Thanks for answer . I have just made a simple test with a userform and textbox to add comment so it will work. But there could be a comment in the cell already and in that case I have to load the textbox with the comment and then edit the comment. Regards Mats -- ESI Update "NickHK" wrote: Mats, You would need to give the user some userform/inputbox to enter their comment, .Unprotect the sheet, add/edit the comment in which cell, .Protect the sheet. NickHk "Mats Nilsson" ... Hi everybody, In Excel 2003 a user can add comment in a protected sheet, if editing objects is allowed. I have to make it possible also in Excel 2000 with VBA code. I¡¦m thinking of using a userform with textbox but maybe there is some better way. Thanks in advance for any suggestion. Best Regards Mats -- ESI Update |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add comment in a protected sheet, Excel 2000
xl2k has the same option to allow users to edit objects. I forget the wording,
but it's one of those boxes on the worksheet protection dialog. Mats Nilsson wrote: Hi everybody, In Excel 2003 a user can add comment in a protected sheet, if editing objects is allowed. I have to make it possible also in Excel 2000 with VBA code. I´m thinking of using a userform with textbox but maybe there is some better way. Thanks in advance for any suggestion. Best Regards Mats -- ESI Update -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a Comment in a Protected Sheet? | Excel Discussion (Misc queries) | |||
Adding a Comment on a protected sheet | Excel Programming | |||
Protected Sheet Problem in Excel 2000 | Excel Programming | |||
Enable filter to work in a protected sheet from Excel 2003 to 2000 | Excel Programming | |||
Query Into Protected Sheet - Excel 2000 on WinXP Home (SR2) | Excel Programming |