Hi,

Not really sure if this should be posted here or in programming...

Here's my latest challenge.

Worksheet that is data entry form for customers has column headings in the
range(B16:V17) of varying widths. Worksheet is protected so that my users
don't overright formulas, etc.
The column widths are formatted so that the text in the headings wraps
nicely and "looks good".
When a user opens the workbook this is the only sheet that is visible.

Problem: The column widths / text formatting is not the same as when it was
saved (or at least is visually different - ie the last letter of the heading
is wrapped onto another line). Since the workbook and worksheet are
protected (again, just so that my users don't make a mess out of the
formulas, etc) they can't reformat the columns to correct the appearance.

I think that this arises because of different monitor sizes or resolutions
(two things I don't have much control of).

Any suggestions?

TIA,

Steve