Okay, I've read the posts about auto sizing merged cells, copied the code,
and the merged cells are resizing, but...

Once I've entered data into the merged field and moved on to the next, I
can't go back and alter the previous merged field.

In case it matters, this is in a protected document. The merged cells are
unlocked. I'm doing this to force users to navigate through the form the
right way.


"Gord Dibben" wrote:

That would be my second or third choice.

First choice.......DO NOT USE MERGED CELLS!!


Gord


On Fri, 1 Feb 2008 10:37:01 -0800, Teri wrote:

Sorry, still couldn't get it to work. I think I'm going to use Word.

"Gord Dibben" wrote:

Or 4. if the code is correct<g

Missed that extra End Sub

See FSt1's post.


Gord

On Thu, 31 Jan 2008 12:29:59 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

The code works fine if all the rules are followed.