Fixing the size of a row

C

cferon

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,
 
W

Wigi

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top