Excel - change the comment arrow
mic13710
Posted messages
1165
Registration date
Status
Member
Last intervention
-
Raymond PENTIER Posted messages 58209 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58209 Registration date Status Contributor Last intervention -
Hello,
I would like to change the size and color of the arrow that by default connects the comment box to the cell.
In Excel 2003, there is indeed an area called "Arrows" in the "Colors and Lines" menu of the comment format, but this section is not accessible (one wonders why it exists.....).
I've searched the web extensively, but I can't find anything on this subject.
Is there a simple method to modify this arrow, and if not, can it be done in VBA and with what instructions?
Thank you in advance for your help.
Configuration: Windows XP / Firefox 3.6.3
I would like to change the size and color of the arrow that by default connects the comment box to the cell.
In Excel 2003, there is indeed an area called "Arrows" in the "Colors and Lines" menu of the comment format, but this section is not accessible (one wonders why it exists.....).
I've searched the web extensively, but I can't find anything on this subject.
Is there a simple method to modify this arrow, and if not, can it be done in VBA and with what instructions?
Thank you in advance for your help.
Configuration: Windows XP / Firefox 3.6.3
4 answers
"There is indeed a section called 'Arrows' in the 'Colors and Lines' menu of the comment format, but this part is not accessible (one wonders why it exists.....)"
This dialog box (which is not a menu) offers tabs whose content is common to many objects, not just comments. When a function/command/option does not apply to the selected object, well, it is grayed out and inaccessible... That's why it exists.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
This dialog box (which is not a menu) offers tabs whose content is common to many objects, not just comments. When a function/command/option does not apply to the selected object, well, it is grayed out and inaccessible... That's why it exists.
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
OK, thank you all three. You confirm what I was thinking.
It's a bit surprising and frustrating not to be able to intervene on this part of the comment, especially since we can modify its form using the drawing menu.
I’ll leave the subject open in case anyone has an idea on the question.
It's a bit surprising and frustrating not to be able to intervene on this part of the comment, especially since we can modify its form using the drawing menu.
I’ll leave the subject open in case anyone has an idea on the question.
Since then, there have been some changes:
https://support.office.com/en-us/article/Annotate-a-worksheet-using-comments-3b7065dd-531a-4ffe-8f18-8d047a6ccae7#bm3
section => Edit the appearance of a comment
https://support.office.com/en-us/article/Annotate-a-worksheet-using-comments-3b7065dd-531a-4ffe-8f18-8d047a6ccae7#bm3
section => Edit the appearance of a comment