Hello everyone,

I've been trying to fix the size of a row : the size of this row is 15 and
whatever the content of my row is, I want it to stay equal to 15 ?

Is it possible ?

Thanks a lot for your help,

What data will you enter in these rows? Is it very likely to increase the row
height?

If you don't want to check this manually, you'll have to use VBA.

Now, VBA can trap certain events, a.o. changing cells, selection cells,
activating a sheet,...

But not the changing of the row height.

Thus, you could write some event procedure, and each time the event occurs,
check for the row heigh. If needed, set it back to 15.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"cferon" wrote:

Hello everyone,

I've been trying to fix the size of a row : the size of this row is 15 and
whatever the content of my row is, I want it to stay equal to 15 ?

Is it possible ?

Thanks a lot for your help,