I don't understand this statement.............

"The colour of the marker did actually change when I
reformatted the fill colour of the comment box (corresponding colour)"

but happy to hear you're satisfied.


Gord

On Sun, 6 Jan 2008 16:12:01 -0800, Jo wrote:


Thanks Gord. The colour of the marker did actually change when I
reformatted the fill colour of the comment box (corresponding colour). I
like your idea of hiding it with a drawing object, given it's not able to be
individually formatted. Thanks for your help.

"Gord Dibben" wrote:

How did you insert "hidden" comments and format them as large text boxes?

Do you mean you just inserted a Comment in a cell using InsertComment and
entered text in that Comment?

The red triangle in top right corner of the cell indicating it has a Comment
cannot be changed to another color.

If you don't like the color or don't want to see the marker, you could use a
Data Validation Input Message instead of a Comment.

Only problem with that method is you have to select the cell to see the message.

Or you could use the drawing toolbar to place a colored shape over the red
marker.

Make sure to set its properties to resize and move with cells.


Gord


On Sun, 6 Jan 2008 15:36:03 -0800, Jo wrote:

Sorry, I shouldn't have used the word "chart". It's only a worksheet (but it
won't be used as a spreadsheet). I have inserted hidden comments and
formatted them as large text boxes.

"Gord Dibben" wrote:

By "Chart" do you mean a graphical chart?

Is this chart on the sheet or is it a separate Chart Sheet?

How did you create the Comments on the chart?


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:56:01 -0800, Jo wrote:

I have created a chart in Excel so I can use comments like pop-up/hover text
boxes to describe the elements on the chart. Now I want to change the
appearance of the comment marker. Can you help me do that?