I have an existing workbook that is used by a large number of people on '03
and '07 (on numerous computers). Until recently, a row height of 25.5 (34
pixels) was adequate (allowed two lines of text), but no longer. I can set
the worksheets to autofit and wrap text in order to grow appropriately and
fit additional lines, but that forces the cells with one line of text to drop
to 12.75 (17 pixels).

This is unacceptable, and I need a minimum cell height of 25.5

Is it possible to change the minimum so autofit won't go below that? I need
it to affect this workbook alone.

You could add a helper column that contains enough text to insure that
autofitting the rowheight will never be smaller than what's required for the
cell in that column.

You could even hide that column.

Another way is to use an event macro that autofits the rowheight and then
adjusts the rowheight if it's not what you like.

But that event macro would depend on the details.

How is the cell changing--by formula or by manual entry by the user?
How many worksheets in this workbook need this?
What rows/cells need this on each sheet?



Raymond W. wrote:

I have an existing workbook that is used by a large number of people on '03
and '07 (on numerous computers). Until recently, a row height of 25.5 (34
pixels) was adequate (allowed two lines of text), but no longer. I can set
the worksheets to autofit and wrap text in order to grow appropriately and
fit additional lines, but that forces the cells with one line of text to drop
to 12.75 (17 pixels).

This is unacceptable, and I need a minimum cell height of 25.5

Is it possible to change the minimum so autofit won't go below that? I need
it to affect this workbook alone.

--

Dave Peterson

I am thinking it may be best to just create this helper column and send it
out to column EE or something just really far from our work. I already tested
that on one sheet and it worked exactly as I hoped. I do prefer a coding
method if possible though as it doesn't eat up a column that may get messed
with some day or forgotten about..

The thing is: 23 sheets, each with several hundred rows (some merged), and
an index with a summary of everything. Every single row contains a
comments/suggestions cell - and for the most part this has always fit in a
cell 300 pixels long and two lines tall. This is becoming infeasible as we
expand into other areas as we are having more than one person leave comments
or suggestions. So this would need to work on every row I already have as
well as any new ones.

If you know of a way to do this code wise, great - but the helper column
will suffice until Office 2010 (hopefully) haha.

Thank you for the suggestion!


"Dave Peterson" wrote:

You could add a helper column that contains enough text to insure that
autofitting the rowheight will never be smaller than what's required for the
cell in that column.

You could even hide that column.

Another way is to use an event macro that autofits the rowheight and then
adjusts the rowheight if it's not what you like.

But that event macro would depend on the details.

How is the cell changing--by formula or by manual entry by the user?
How many worksheets in this workbook need this?
What rows/cells need this on each sheet?

The addition of merged cells makes it more difficult.

I would use the helper column if that works.

Raymond W. wrote:

I am thinking it may be best to just create this helper column and send it
out to column EE or something just really far from our work. I already tested
that on one sheet and it worked exactly as I hoped. I do prefer a coding
method if possible though as it doesn't eat up a column that may get messed
with some day or forgotten about..

The thing is: 23 sheets, each with several hundred rows (some merged), and
an index with a summary of everything. Every single row contains a
comments/suggestions cell - and for the most part this has always fit in a
cell 300 pixels long and two lines tall. This is becoming infeasible as we
expand into other areas as we are having more than one person leave comments
or suggestions. So this would need to work on every row I already have as
well as any new ones.

If you know of a way to do this code wise, great - but the helper column
will suffice until Office 2010 (hopefully) haha.

Thank you for the suggestion!

"Dave Peterson" wrote:

You could add a helper column that contains enough text to insure that
autofitting the rowheight will never be smaller than what's required for the
cell in that column.

You could even hide that column.

Another way is to use an event macro that autofits the rowheight and then
adjusts the rowheight if it's not what you like.

But that event macro would depend on the details.

How is the cell changing--by formula or by manual entry by the user?
How many worksheets in this workbook need this?
What rows/cells need this on each sheet?

--

Dave Peterson