View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Wigi Wigi is offline
external usenet poster
 
Posts: 396
Default Fixing the size of a row

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,