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

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" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:8ED6BC05-1932-485B-8950-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:8ED6BC05-1932-485B-8950-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:8ED6BC05-1932-485B-8950-(E-Mail Removed)...
> > > 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
> >
> >
> >

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