Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
elai
 
Posts: n/a
Default 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!

  #2   Report Post  
Max
 
Posts: n/a
Default

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!



  #3   Report Post  
elai
 
Posts: n/a
Default

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.

  #4   Report Post  
Max
 
Posts: n/a
Default

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.



Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How can I retrive the contents of a comment box in microsoft excel Rg Excel Discussion (Misc queries) 1 February 22nd 05 07:57 AM
j'aimerais aller voir comment utiliser le remplissage dans excel amyka Excel Discussion (Misc queries) 1 February 13th 05 05:38 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
comment indicators should feature lock or pw protect limiting acc. summer_rose Excel Worksheet Functions 1 December 3rd 04 07:02 AM


All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"