Install Button that toggles between hiding and unhiding certain columns

[redbarnxoxo1]

Could someone please respond to an ignorant Excel User with steps to:

1) Install a button
2) The macro behind the button needs to hide columns D, F, H, J
3) The same botton if pushed again unhides D, F, H, J


Please respond with step by step, I am not a smarty.

Thanks so much

 

[Smitty]

Welcome to the Board!

You can use:

<font face=Calibri><SPAN style="color:#00007F">Sub</SPAN> ToggleColumns()<br>    Range("D:D, F:F, H:H, J:J").EntireColumn.Hidden = <SPAN style="color:#00007F">Not</SPAN> Range("D:D, F:F, H:H, J:J").EntireColumn.Hidden<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

Open the VBE with ALT+F11, then Insert-->Module, paste the above in and exit back to Excel with ALT+Q.

Then you can draw a shape, and when you're done, right-click, choose Assign Macro and select "ToggleColumns".

That's all there is to it.

HTH,

 

[redbarnxoxo1]

HTH thanks so much. It worked! and I am a beginner. Thank you thank you thank you!!!