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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|