ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   New Excel Comment Box Issue (https://www.excelbanter.com/excel-discussion-misc-queries/14393-new-excel-comment-box-issue.html)

elai

New Excel Comment Box Issue
 
My Excel comment boxes are showing up as a solid black box. On the
surface, it looks like the same issue as all the other posts that I
have read. I'm running Office 2000 on Windows 2000 desktop. This has
suddenly stopped working in the past week or so. I'm having problems
with all spreadsheets with comments. I can access the spreadsheet on
different computers without problems - all with the same setup. I have
tried the following to no avail-

Reinstalling Excel (2000)

Checking the settings for the comment boxes - my settings are
fill color: automatic
style is set to 3/4 pt
weight is set to .75 pt

Changing the default in Control Panel: Go to Windows Control Panel
Display Property appearance tab at scheme dropdown box set at
"Windows Standard"

Changing the color resolution to 32-bit

I've read thru the thread provided by David McRitchie and didn't see
any other solutions.
http://www.mvps.org/dmcritchie/excel...ent.htm#colors

Nothing seems to work. The only way to see the comment, is to edit it
or to remove the border completely. I can't imagine that that is the
fix - I would need to remove all borders from all comment boxes in all
spreadsheets to see them?

At this point, I'm about ready to throw my computer out the window.
Please help!


Max

Not sure, but maybe try ...

In Windows desktop
Right click on any empty point choose Properties
In Display Properties dialog, select Appearance tab
Choose "Tooltip" under Item droplist
and adjust the Color to light yellow?
Click Apply OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"elai" wrote in message
ups.com...
My Excel comment boxes are showing up as a solid black box. On the
surface, it looks like the same issue as all the other posts that I
have read. I'm running Office 2000 on Windows 2000 desktop. This has
suddenly stopped working in the past week or so. I'm having problems
with all spreadsheets with comments. I can access the spreadsheet on
different computers without problems - all with the same setup. I have
tried the following to no avail-

Reinstalling Excel (2000)

Checking the settings for the comment boxes - my settings are
fill color: automatic
style is set to 3/4 pt
weight is set to .75 pt

Changing the default in Control Panel: Go to Windows Control Panel
Display Property appearance tab at scheme dropdown box set at
"Windows Standard"

Changing the color resolution to 32-bit

I've read thru the thread provided by David McRitchie and didn't see
any other solutions.
http://www.mvps.org/dmcritchie/excel...ent.htm#colors

Nothing seems to work. The only way to see the comment, is to edit it
or to remove the border completely. I can't imagine that that is the
fix - I would need to remove all borders from all comment boxes in all
spreadsheets to see them?

At this point, I'm about ready to throw my computer out the window.
Please help!




elai

Thanks for the reply Max. I had failed to mention that I already tried
that as well - tried a couple of different colors, but still no luck.

David McRitchie had also suggusted that I try adding another printer
and choosing that one as the default - that also did not work.


Max

You're welcome. Out of ideas on this, sorry.
Hang around awhile for better insights from others ..
Good luck !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"elai" wrote in message
ups.com...
Thanks for the reply Max. I had failed to mention that I already tried
that as well - tried a couple of different colors, but still no luck.

David McRitchie had also suggusted that I try adding another printer
and choosing that one as the default - that also did not work.





All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com