Hide Certain Columns

[Excel-ent]

Dear Experts,

I have 6 sheets named "1", "2", "3", "4", "5", "6" in which i want columns (D:F) to be hidden with a help of a commandbutton, and show the same hidden columns from another commandbutton.

How can i do this.

Thank you for your help.

 

[RAM]

Use the macro recorder and record what you want the macro to perform.

HTH

RAM