Protect part of Insert comment
is it possible
No it's not possible to lock part of a comment box. A complicated
workaround would be to lock the cell and allow editing only through a macro
(using InputBox or a userform) which could protect the user name part of the
comment.
--
Jim
"KP" wrote in message
...
| Hi,
| When right click and Insert comment is used, is it possible through macro
| code to protect the default inserted username in the text box, so that it
| cannot be deleted with the Delete or back space key?
| I still want the possibility to write my own text in the box.
| I know that I can protect the whole cell, but this is not what I want.
|
| Regards,
| K. Pedersen
|
|
|