fixed formatting on a protected sheet
 

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

fixed formatting on a protected sheet
 

What version of Excel?
If you are using Excel 2003, when you go to protect the sheet, there's an
option that you can select to enable "Format Columns" - which would solve the
case in general. Just be advised that it would permit other types of
formatting besides the width, and wouldn't restrict formatting to any
specific column(s).

Another option would be to set the header cell's width and height with some
extra space to allow for such changes and then rather than just depending on
'Wrap Text' property in the cell to do it, use [Alt]+[Enter] to force line
breaks in the text in those cells where you want them to appear?

"Steve E" wrote:

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

fixed formatting on a protected sheet
 

J,

Thanks for the quick reply. I'm using XL2003.
I don't think that the enabling of "Format Columns" will help me because I
have a _Before Save event that disables my users from being able to save the
original workbook (so that they don't overwrite formulaes and to force an
email registration routine) but I'm going to try the suggestion about the
wider columns and using [Alt]+[Enter] to force the word wraps -- I didn't
know that this was an available command!!!

Thanks!

Steve

"JLatham" wrote:

What version of Excel?
If you are using Excel 2003, when you go to protect the sheet, there's an
option that you can select to enable "Format Columns" - which would solve the
case in general. Just be advised that it would permit other types of
formatting besides the width, and wouldn't restrict formatting to any
specific column(s).

Another option would be to set the header cell's width and height with some
extra space to allow for such changes and then rather than just depending on
'Wrap Text' property in the cell to do it, use [Alt]+[Enter] to force line
breaks in the text in those cells where you want them to appear?

"Steve E" wrote:

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

fixed formatting on a protected sheet
 

That's the way you get a newline while within a cell. As you probably
already realize, just pressing the [enter] key by itself will take you
elsewhere!

Good luck with it. That type of problem is typical, especially if you work
at a higher resolution screen than your end users do. Trying to plan ahead
while designing in a 1024x768 or 1280x1024 or 1600x1200 setting for someone
who is sitting somewhere with a 20" monitor set at 600x800 only because they
never outgrew their need for MS-DOS and VGA, can be a challenge.

"Steve E" wrote:

J,

Thanks for the quick reply. I'm using XL2003.
I don't think that the enabling of "Format Columns" will help me because I
have a _Before Save event that disables my users from being able to save the
original workbook (so that they don't overwrite formulaes and to force an
email registration routine) but I'm going to try the suggestion about the
wider columns and using [Alt]+[Enter] to force the word wraps -- I didn't
know that this was an available command!!!

Thanks!

Steve

"JLatham" wrote:

What version of Excel?
If you are using Excel 2003, when you go to protect the sheet, there's an
option that you can select to enable "Format Columns" - which would solve the
case in general. Just be advised that it would permit other types of
formatting besides the width, and wouldn't restrict formatting to any
specific column(s).

Another option would be to set the header cell's width and height with some
extra space to allow for such changes and then rather than just depending on
'Wrap Text' property in the cell to do it, use [Alt]+[Enter] to force line
breaks in the text in those cells where you want them to appear?

"Steve E" wrote:

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