View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default 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
|
|