Double Click to Expand Row to Specific Amount

[Darkcloud617]

Hello,

I am not even sure if this is possible but I am looking for a VBA code that will automatically resize the active row to 400 with a double click. Then if double clicked again it would go back to the default size.

I have data that is linked to another sheet and the text that is linked can sometimes be a paragraph or two long. It would be helpful if we could just double click and resize the row to a specific amount, as autofit does not work for the linked data properly. Is it possible to do that for the entire sheet no matter what row is double clicked? We will not be using the double click for anything else.

Thank you in advance for any assistance.

[mehmetcik]

Right Click on the sheet name at the bottom of excel and select view code.

Paste this code into the module that opens and close it.

Please Login or Register  to view this content.

[Darkcloud617]

Thank you so much. That done exactly what I was needing.

[Nigep]

I've just copied that for myself . I was doing it manually !