Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
bosforus
 
Posts: n/a
Default annoying red triangle


Hello. does anyone know how I can get rid of that pesky red triangle
that shows up when i make a comment on a cell? i know they're useful,
but it just looks awful.


--
bosforus
------------------------------------------------------------------------
bosforus's Profile: http://www.excelforum.com/member.php...o&userid=33621
View this thread: http://www.excelforum.com/showthread...hreadid=554285

  #2   Report Post  
Posted to microsoft.public.excel.misc
Mallycat
 
Posts: n/a
Default annoying red triangle


You can turn it off in the Options\View\Comments section, but they you
wont be able to see the comments either. You can see them again if you
turn it back on. The only other way I know it is colour your entire
cell red :)


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=554285

  #3   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default annoying red triangle

You might wish to try the,
<Data <Validation <Input Message

This leaves no marking in/on the cell but *only* shows the message when the
cell is selected.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bosforus" wrote in
message ...

Hello. does anyone know how I can get rid of that pesky red triangle
that shows up when i make a comment on a cell? i know they're useful,
but it just looks awful.


--
bosforus
------------------------------------------------------------------------
bosforus's Profile:
http://www.excelforum.com/member.php...o&userid=33621
View this thread: http://www.excelforum.com/showthread...hreadid=554285


  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim May
 
Posts: n/a
Default annoying red triangle

At the menu, Tools, Options, View Tab - near middle Comments - select
None.


"bosforus" wrote
in message :

Hello. does anyone know how I can get rid of that pesky red triangle
that shows up when i make a comment on a cell? i know they're useful,
but it just looks awful.


--
bosforus
------------------------------------------------------------------------
bosforus's Profile: http://www.excelforum.com/member.php...o&userid=33621
View this thread: http://www.excelforum.com/showthread...hreadid=554285


  #5   Report Post  
Posted to microsoft.public.excel.misc
bosforus
 
Posts: n/a
Default annoying red triangle


thanks, ragdyer. that should work. in fact, it's even more practical
than a comment for my purpose!

jim may, the comment also doesn't show up when I click on 'none' as you
suggested. if there was a way to just get rid of the triangle without
eliminating the comment, that'd be nice.

Thanks!


--
bosforus
------------------------------------------------------------------------
bosforus's Profile: http://www.excelforum.com/member.php...o&userid=33621
View this thread: http://www.excelforum.com/showthread...hreadid=554285



  #6   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default annoying red triangle

You're welcome, and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bosforus" wrote in
message ...

thanks, ragdyer. that should work. in fact, it's even more practical
than a comment for my purpose!

jim may, the comment also doesn't show up when I click on 'none' as you
suggested. if there was a way to just get rid of the triangle without
eliminating the comment, that'd be nice.

Thanks!


--
bosforus
------------------------------------------------------------------------
bosforus's Profile:

http://www.excelforum.com/member.php...o&userid=33621
View this thread: http://www.excelforum.com/showthread...hreadid=554285


  #7   Report Post  
Posted to microsoft.public.excel.misc
Samad
 
Posts: n/a
Default annoying red triangle

Hi,
If you want to change colour of comment indicator, here is alternate try
this, there are other tips regarding comments.

http://www.contextures.com/xlcomments02.html

Regds.
A. Samad
samad.gadit@gmail

"bosforus" wrote:


Hello. does anyone know how I can get rid of that pesky red triangle
that shows up when i make a comment on a cell? i know they're useful,
but it just looks awful.


--
bosforus
------------------------------------------------------------------------
bosforus's Profile: http://www.excelforum.com/member.php...o&userid=33621
View this thread: http://www.excelforum.com/showthread...hreadid=554285


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
removing green triangle in cell Shooter Excel Worksheet Functions 4 May 7th 23 11:45 AM
indicator triangle Mail Merge labels for price Charts and Charting in Excel 1 April 27th 06 05:27 PM
allow user to disable annoying warning dialog on log charts Roger Charts and Charting in Excel 3 September 13th 05 01:26 PM
Copy-Paste / Excel 2002 (Annoying) Maxwell-5000 Excel Discussion (Misc queries) 1 August 25th 05 10:42 PM
Copy Paste / Excel 2002 (Annoying) Maxwell-5000 Excel Discussion (Misc queries) 9 August 20th 05 02:27 AM


All times are GMT +1. The time now is 05:02 PM.

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

About Us

"It's about Microsoft Excel"