Macro to autofit row height, and then reduce back to original height

Hi there,

I have a row of data that is particularly large and need to keep it at reasonable height so that other information can be seen in one glance. However, the data needs to be read so I need a macro that autofits the row height when clicked, and then reduces back to original height in the next click...

If anyone can help it would be so appreciated!

Thanks
Lesley

Below is VBA code that was tested in Excel 2003. A command button is clicked to expand row heights
for all rows where cells are selected, then click the button again and all data rows
row heights are returned to normal. A file is attached. I hope you can test this file in Excel 2000.

Please Login or Register  to view this content.