Change Color of Cell Comment Indicator
I would like to be able to change the color of the cell
comment indicator via programming (e.g. red, yellow, green depending on severity of a particular comment). I see no object reference to the color of the indicator nor have I been able to come up with any workaround... any ideas out there on how to do this? I am very surprised that Excel would not give you the ability to do this. |
Change Color of Cell Comment Indicator
Browse through this.
http://www.google.com/groups?as_epq=...n&num=50&hl=en HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- I would like to be able to change the color of the cell comment indicator via programming (e.g. red, yellow, green depending on severity of a particular comment). I see no object reference to the color of the indicator nor have I been able to come up with any workaround... any ideas out there on how to do this? I am very surprised that Excel would not give you the ability to do this. |
Change Color of Cell Comment Indicator
Sub ModifyComment()
With ActiveCell.Comment.Shape .Fill.Visible = msoTrue .Fill.Solid .Fill.ForeColor.SchemeColor = 52 .Fill.Transparency = 0# .Line.Weight = 0.75 .Line.DashStyle = msoLineSolid .Line.Style = msoLineSingle .Line.Transparency = 0# .Line.Visible = msoTrue .Line.ForeColor.RGB = RGB(0, 0, 0) .Line.BackColor.RGB = RGB(255, 255, 255) End With End Sub -- Regards, Tom Ogilvy "Michael" wrote in message ... I would like to be able to change the color of the cell comment indicator via programming (e.g. red, yellow, green depending on severity of a particular comment). I see no object reference to the color of the indicator nor have I been able to come up with any workaround... any ideas out there on how to do this? I am very surprised that Excel would not give you the ability to do this. |
Change Color of Cell Comment Indicator
Disregard - I thought you meant the background color - somehow I missed the
Indicator part. -- Regards, Tom Ogilvy Tom Ogilvy wrote in message ... Sub ModifyComment() With ActiveCell.Comment.Shape .Fill.Visible = msoTrue .Fill.Solid .Fill.ForeColor.SchemeColor = 52 .Fill.Transparency = 0# .Line.Weight = 0.75 .Line.DashStyle = msoLineSolid .Line.Style = msoLineSingle .Line.Transparency = 0# .Line.Visible = msoTrue .Line.ForeColor.RGB = RGB(0, 0, 0) .Line.BackColor.RGB = RGB(255, 255, 255) End With End Sub -- Regards, Tom Ogilvy "Michael" wrote in message ... I would like to be able to change the color of the cell comment indicator via programming (e.g. red, yellow, green depending on severity of a particular comment). I see no object reference to the color of the indicator nor have I been able to come up with any workaround... any ideas out there on how to do this? I am very surprised that Excel would not give you the ability to do this. |
All times are GMT +1. The time now is 11:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com