On rare occasions Excel 2003 (with all updates) screws up and will display
just one sheet with impossibly tiny text - like only one or two pels high on
the screen. All other sheets continue to look normal. All the cells appear
to still have correct information in them, it's just tiny.
I can select the entire sheet and tell it to use 100 point type and it will
produce type that looks like maybe 10 point type on the other sheets. Or I
can copy an entire good sheet, and "Paste Special" only the formats onto the
bad sheet and get back the impossibly tiny text again. Saving and reloading
the workbook doesn't help any.
To the best I can tell, this rare occurrence only happens when I've been
running VBA for an hour or so at the same time that the computer is doing
other things in the foreground. Excel will continue to look fine until the
VBA stops and kicks back to Excel, whereupon Excel displays the tiny text.
Does this sound familiar to anyone? Any suggestions?
Thanks.
Bill
Gary''s Student - 18 Sep 2006 17:19 GMT
Tiny, tiny text usually results from accidentally leaving the application in
PageBreak View with a large range.

Signature
Gary's Student
> On rare occasions Excel 2003 (with all updates) screws up and will display
> just one sheet with impossibly tiny text - like only one or two pels high on
[quoted text clipped - 17 lines]
>
> Bill
Beege - 18 Sep 2006 17:20 GMT
> On rare occasions Excel 2003 (with all updates) screws up and will display
> just one sheet with impossibly tiny text - like only one or two pels high
[quoted text clipped - 18 lines]
>
> Bill
Bill,
It's been my (limited) experience that your text isn't really tiny. You're
just in a zoom way out (10%?). Set your zoom to whatever your other sheets
are set .
Beege
Bill Martin - 18 Sep 2006 18:08 GMT
>> On rare occasions Excel 2003 (with all updates) screws up and will
>> display just one sheet with impossibly tiny text - like only one or two
[quoted text clipped - 27 lines]
>
> Beege
-----------------------------------------
You put your finger right on it. I've never noticed or played with the zoom
before, so I don't know how it get's changed but that one sheet was set to
10% rather than 100% like all the others.
Thanks.
Bill
Jim Thomlinson - 18 Sep 2006 20:45 GMT
Hold down the Ctrl key and scroll the wheel on your mouse. That will change
the zoom without touching the Zoom setting...

Signature
HTH...
Jim Thomlinson
> >> On rare occasions Excel 2003 (with all updates) screws up and will
> >> display just one sheet with impossibly tiny text - like only one or two
[quoted text clipped - 36 lines]
>
> Bill