Fonts and scrolling (Excel 2000)

[BCKessinger]

Hello all:

Two questions:

1. Can the default font size for comments be changed & how?

2. Can tiled spreadsheets be sync'ed so they can be scrolled together & how?

TIA for any and all assistance.

[TonyE]

Hi Bill

1. The font size for comments is picked up from the font size for tool tips. To change the size do the following (instructions for Windows XP)
<UL><LI>Right-click on the desktop and select Properties
<LI>On the Appearance tab click Advanced.
<LI>From the Item dropdown select Tooltip
<LI>Choose a font Size then click OK twice[/list]2.Synchronized scrolling was introduced in Excel 2003 (called compare side by side).

[TonyE]

Just remembered, you can also manually change the font size in comments.
Edit the comment, highlight the text and you can then change the font size using the formatting toolbar.

[BCKessinger]

Tony: Thanks for your reply. We knew about manually changing, the default is what's needed. I'll have to upgrade the user to Excel 2003 for the synchronized scrolling. Thanks again.

[sdckapr]

<P ID="edit" class=small>(Edited by sdckapr on 02-Jul-04 07:56. Added PS with a better post)</P>Check out <post#=264633>post 264633</post#> for some code to change the comments after the fact to the desired size/ color, etc. Modify as needed.

I generally don't recommend changing the tooltip default, since it affects most windows programs not just excel comments.

Steve
PS <post#=290956>post 290956</post#> is probably better since it avoids selecting. It also changes the fill color.

[HansV]

1. see the replies to <post#=290786>post 290786</post#>.

2. Synchronized scrolling was introduced in Excel 2003 (some 15 years after Lotus 1-2-3.) You can synchronize two windows on the same worksheet in code: see Can't Synchronize Windows By Choosing Arrange All