Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default 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?
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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?


  #5   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default 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???


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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???



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color change for comment indicators CarolM Setting up and Configuration of Excel 5 February 23rd 07 11:45 PM
How can I change the color of the comment indicators? azveteran Excel Worksheet Functions 15 May 16th 06 01:26 AM
comment indicator changing the color or hiding the indicators Giovanni Excel Discussion (Misc queries) 2 September 3rd 05 12:37 AM
Allow users to change the color of the comment indicator color so. DanC Excel Discussion (Misc queries) 1 February 25th 05 05:15 PM
Change Color of Cell Comment Indicator Michael[_19_] Excel Programming 3 October 10th 03 10:35 PM


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"