Unreadable Comment Boxes

[Gordon]

I created a workbook, and some of the cells on the sheets hace comments.
The workbook is used by about 10 different people, everyone uses office 2000.
When some of us open the workbook and put the pointer over a cell with a comment we see the comment without any problem. 2 or 3 of the people when they put the pointer over a cell with a comment all they see is a black square and they can't read the comment. The sheets are locked.

Any Idea why this is happening and how I can fix it so everyone can see the comments?

Thank you.

 

[David McRitchie]

Hi Gordon,

Q173798 -- XL97: How to Change the Font in a Cell Comment,
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q173798
macros to change an existing Comment or all comments in a workbook.

Sometimes the cell border is responsible for the entire comment box turns black
or real wide borders. change the border width, by formatting the individual comment,
and for the default --
Go to Windows Control Panel, Display Property, appearance tab, at the scheme
dropdown box set Default Windows. (Orlando Filho, 2001-10-08 worksheet functions).

Another cause mentioned was having color resolution at 16-bit instead of at least 32-bit
for Graphics card (Sonny 2002-02-02), and also mentioned reducing the HW
acceleration would also make it work properly -- these setting are under Settings,
Control Panel then Display, Settings (tab), Colors. The speed is also from the Control
Panel then Systems icon, the Performance (tab), Graphics [button] then scale.

If you have additional problems with comment boxes see my
http://www.mvps.org/dmcritchie/excel/ccomment.htm
or for information concerning colors in
http://www.mvps.org/dmcritchie/excel/colors.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I created a workbook, and some of the cells on the sheets hace comments.
The workbook is used by about 10 different people, everyone uses office 2000.
When some of us open the workbook and put the pointer over a cell with a comment we see the comment without any problem. 2 or 3

of the people when they put the pointer over a cell with a comment all they see is a black square and they can't read the comment.
The sheets are locked.

 

[lunker55]

I'm not sure if it is the same as us, but we have a similar problem.
Sometimes a comment is completely flattened, so when you mouse over the
comment, all you see is a black line.
In order to see it, you have to stretch it back with your mouse.

Joe

I created a workbook, and some of the cells on the sheets hace comments.
The workbook is used by about 10 different people, everyone uses office 2000.
When some of us open the workbook and put the pointer over a cell with a

comment we see the comment without any problem. 2 or 3 of the people when
they put the pointer over a cell with a comment all they see is a black
square and they can't read the comment. The sheets are locked.

 

[David McRitchie]

Hi Joe,
Yours sound like a different problem for which, ...

The following may be a fixup if you have serious problems for
size of the comment box. (Format, Alignment, Automatic size). .

Sub FitComments()
Dim c As Comment
For Each c In ActiveSheet.Comments
c.Shape.TextFrame.AutoSize = True
Next c
End Sub

Additional solutions such as fixed dimensions can be found
on or from my Cell Comments page
http://www.mvps.org/dmcritchie/excel/ccomment.htm

 

[lunker55]

Thanks David.

Joe

Hi Joe,
Yours sound like a different problem for which, ...

The following may be a fixup if you have serious problems for
size of the comment box. (Format, Alignment, Automatic size). .

Sub FitComments()
Dim c As Comment
For Each c In ActiveSheet.Comments
c.Shape.TextFrame.AutoSize = True
Next c
End Sub

Additional solutions such as fixed dimensions can be found
on or from my Cell Comments page
http://www.mvps.org/dmcritchie/excel/ccomment.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I'm not sure if it is the same as us, but we have a similar problem.
Sometimes a comment is completely flattened, so when you mouse over the
comment, all you see is a black line.
In order to see it, you have to stretch it back with your mouse.

Joe

 

[Gordon]

Thank you, changing the resolution to 32 worked great.

--
Gordon

Hi Gordon,

Q173798 -- XL97: How to Change the Font in a Cell Comment,
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q173798
macros to change an existing Comment or all comments in a workbook.

Sometimes the cell border is responsible for the entire comment box turns black
or real wide borders. change the border width, by formatting the individual comment,
and for the default --
Go to Windows Control Panel, Display Property, appearance tab, at the scheme
dropdown box set Default Windows. (Orlando Filho, 2001-10-08 worksheet functions).

Another cause mentioned was having color resolution at 16-bit instead of at least 32-bit
for Graphics card (Sonny 2002-02-02), and also mentioned reducing the HW
acceleration would also make it work properly -- these setting are under Settings,
Control Panel then Display, Settings (tab), Colors. The speed is also from the Control
Panel then Systems icon, the Performance (tab), Graphics [button] then scale.

If you have additional problems with comment boxes see my
http://www.mvps.org/dmcritchie/excel/ccomment.htm
or for information concerning colors in
http://www.mvps.org/dmcritchie/excel/colors.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I created a workbook, and some of the cells on the sheets hace comments.
The workbook is used by about 10 different people, everyone uses office 2000.
When some of us open the workbook and put the pointer over a cell with a comment we see the comment without any problem. 2 or 3

of the people when they put the pointer over a cell with a comment all they see is a black square and they can't read the comment.
The sheets are locked.