Hi, and thank you for trying to solve my Excel problem.
Unfortunately, your suggestion has not helped when I right click and choose
"New note" (I had expected the special text to be inserted).
Instead of getting my special text I get the standard text with my name in
bold as usual. Your VBA works when I run it as a normal macro and so did my
own.

That means the problem is not the vba inserted in module1, but the VBA
inserted in "This workbook" that points to the module 1.
I hope you or somebody else will give it another try.

In fact, my worry is that Microsoft has discontinued the previously working
vba code in Office 365 when they introduced "New note" and "New comment".

Kind regards,
Kaj Pedersen

I made a utility named CommentsManager.xla[m] some years back that still works
in 365 as expected. Working code hasn't changed (yet) for the Comment object
even though it has been re-defined in the UI as "Note". In VBA the UI term
"Comment" now refers to "CommentThreaded"! It appears that a cell can't have
both a Comment and a Note at the same time.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion