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

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

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

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

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