Hide Certain Columns

Excel-ent

Active Member
Joined
Mar 4, 2004
Messages
338
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.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

RAM

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
Use the macro recorder and record what you want the macro to perform.

HTH

RAM
 

Watch MrExcel Video

Forum statistics

Threads
1,118,282
Messages
5,571,300
Members
412,378
Latest member
bill4123
Top