ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Comment Indicators - can I change the color of the little indicator ... (https://www.excelbanter.com/excel-programming/289622-comment-indicators-can-i-change-color-little-indicator.html)

dan

Comment Indicators - can I change the color of the little indicator ...
 
Can I change the color of the little indicator - "they" hade the red

Also can I autosize the indicator box somehow?

Tom Ogilvy

Comment Indicators - can I change the color of the little indicator ...
 
To the best of my knowledge,

No to both (except the size might look different if you zoom, but so will
everything else).

--
Regards,
Tom Ogilvy

"dan" wrote in message
...
Can I change the color of the little indicator - "they" hade the red!

Also can I autosize the indicator box somehow?




dan

Comment Indicators - can I change the color of the little indicator ...
 
Thanks Tom - actually I misphrased my second question - can I autosize the comment shape so that the whole comment is visible?

Tom Ogilvy

Comment Indicators - can I change the color of the little indicator ...
 
Yes and no. Unless you have hard line returns embedded in the text, if you
autosize, you will get a single row of text stretching out as far as needed.
I doubt that is what you want.

--
Regards,
Tom Ogilvy

"dan" wrote in message
...
Thanks Tom - actually I misphrased my second question - can I autosize the

comment shape so that the whole comment is visible?



dan

Comment Indicators - can I change the color of the little indicator ...
 
Actually Tom since I generate the text putting in the hard returns would be no problemo. It sounds like you have a way to size the vertical large enough for the pre line returned text

If I may ask what you got???

Tom Ogilvy

Comment Indicators - can I change the color of the little indicator ...
 
If you put in the hard returns at regular intervals, then the autosize will
work as you probably would expect.

--
Regards,
Tom Ogilvy

"dan" wrote in message
...
Actually Tom since I generate the text putting in the hard returns would

be no problemo. It sounds like you have a way to size the vertical large
enough for the pre line returned text.

If I may ask what you got???





All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com