Auto Row Height Protected Template

[IlanK]

Hi,

I have a template that I created in Excel.
When I enter text in the unlocked cells I'd like for the row height to automatically adjust (it's on wrap text at the moment).

I'm not very familiar with macro coding, so how do I do this?

Thanks!

[xladept]

Hi Ilank,

Something like this:

Please Login or Register  to view this content.

[IlanK]

Xladept, how do I make it apply to the entire spreadsheet and where do I place the code?

[IlanK]

Sorry, I should add the cell is merged.

[xladept]

When you enter the text - you could use the Worksheet_Change event:

Please Login or Register  to view this content.

You would place the code right in the Worksheet in question.