A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Unreadable Comment Boxes



 
 
Thread Tools Display Modes
  #1  
Old June 11th, 2004, 10:52 PM
Gordon
external usenet poster
 
Posts: n/a
Default Unreadable Comment Boxes

Thank you, changing the resolution to 32 worked great.

--
Gordon



"David McRitchie" wrote:

Hi Gordon,

Q173798 -- XL97: How to Change the Font in a Cell Comment,
http://support.microsoft.com/default...;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


"Gordon" wrote in message ...
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.
--
Gordon




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:23 PM.


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