hide unhide columns with selected cells change font size

Hi
I have recorded macro.
What I am trying to achieve is ....
When I select cell A2 and press command button
Then
- Columns C, D, E are unhidden
-Relative cells in selected row ( in this case C2,D2,E2) change font to 12
- When command button is pressed then C,D,E are hidden and font size goes back to 1

similarly if i select A3 same should happen to C3,D3,E3
Currently all is OK but when I press command button it all happens with the entire column C,D,E
Sample book attached.
Code is as follows:

Please Login or Register  to view this content.

Thanks

Hi Joakim N,
Thanks
It works fine. Great.
Small issue:
previously enlarged fonts in other cells remain enlarged and do not return to their original small size.
Any suggestions please.
Many thanks
Kind regards

Hi again,
It works perfect now. You got to stick to one row at a time.
If you select one row and font is enlarged, and now if you now go to another row, the previously selected font remains enlarged.

is there any way we can say at the end of sub, that all fonts not in selected row / range go to size 2

Great solution by you.
Thanks
Kind regards

Hi John H Davis,
Really thanks.
issue is resolved perfectly.
Thanks again
Kind regards

You're welcome. Glad to help out and thanks for the feedback.