Automating hiding and collapse of row height......possible?

Hi (this is my second post)

I have a situation with a worksheet which has 8 columns:

Columns 1-3 are row height 15 (just one line of text) - or would be, except they automatically go to row height of 80, because columns 4-8 have much more text and so it is expanded to height of 80.

I want to switch between (1) seeing everything at row height 80 (or what it automatically goes to) and (2) hiding columns 4-8 and everything being at row height 15. So I want a button with a macro behind it to do that.

Is this possible?

Many thanks in advance.

This code assigned to a button does the task.

Please Login or Register  to view this content.

Many thanks