Autofit row height on select merged cells

[Serjape]

We have an excel sheet that has various merged and non-merged cells on it. If someone typs more than the width of a cell that is merged it DOES wrap but does not show all content if there are multiple lines. In other words I know i can't use FORMAT | Autofit Row Height like a you can in non-merged cell. We CAN maually adjust but user do not have that option as we lock it down. I know there is a way with VBA but that is beyond me. Anyone can help?

 

[breynolds0431]

We have an excel sheet that has various merged and non-merged cells on it. If someone typs more than the width of a cell that is merged it DOES wrap but does not show all content if there are multiple lines. In other words I know i can't use FORMAT | Autofit Row Height like a you can in non-merged cell. We CAN maually adjust but user do not have that option as we lock it down. I know there is a way with VBA but that is beyond me. Anyone can help?

Check out How to auto fit row height of merged cells in Excel?

 

[Serjape]

Check out How to auto fit row height of merged cells in Excel?

I recall that from a while ago but when i tried to use it it autofit the whole shhet. I do not want that.

 

[Serjape]

I got some help on the Autofit for merged cells. What i want to know now is can I somehow stop users from manually resizing rows or columns or from even adding rows and not affect the vba autofit row height for merged cells?