LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default Any way to change the color of the cell corner identifier that shows a comment is present?

I'm working on a project that adds a lot of comments to the cells in my
workbook. I know that any cell that has data in it will also have a comment,
so the visual identification with the red triangle in the upper right of
each of those cells is redundant (and distracting).

Worst case, I'd like to know if there is some way to turn that triangle off,
or change the color to white so it isn't noticable.

Best case, I'd like to know if there is any way to programatically modify
the color of that triangle by cell, so I could make most of them white but
optionally leave a few red if there was a particularly important comment in
that cell.

I realize this may be way outside of what Excel allows, but it never hurts
to ask. I'm open to VBA solutions as well, but figured a misc newsgroup
would be the place to start. The only thing I can't do is anything that
requires changes to the registry, as our IT department locked down all
machines and I don't have permission to change the registry on my computer
or those of the other users of the workbook.

Thanks,
Keith


 
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
How to change text color in a cell "comment" in Office 2007? conductor Excel Worksheet Functions 1 June 2nd 07 02:50 AM
Color change for comment indicators CarolM Setting up and Configuration of Excel 5 February 23rd 07 11:45 PM
How do I move comment indicator to different corner of cell? TVK Excel Worksheet Functions 1 February 8th 07 11:36 PM
How can I change the color of the comment indicators? azveteran Excel Worksheet Functions 15 May 16th 06 01:26 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


All times are GMT +1. The time now is 01:10 AM.

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"