Hiding columns with a macro

**bmw30csl** · 05-13-2009, 08:26 AM

Hi guys, I am a real excel amateur - how do I go about creating a macro which I can click to hide a certain set of columns in a spreadsheet?

Any help greatly appreciated.

Regards,

Rohan

**martindwilson** · 05-13-2009, 08:33 AM

easiest way is to record one. start the macro recorder then do your hide columns
stop recording
then start recording again and do another one to unhide.
now if you look in the macros you will see 2 macros macro1 and macro2 run either of these to do the job
i'm not sure wher the menu is in 2007 tho'
http://excel2007tips.blogspot.com/20...xcel-2007.html

**Simon Lloyd** · 05-13-2009, 08:42 AM

If you simply want to hide the columns you have selected then use the code below, however it can be easily adapted to hide a range of columns. Assign each of the macro's to a button so you can hide/unhide the columns.

Please Login or Register  to view this content.

**Simon Lloyd** · 05-13-2009, 08:45 AM

Originally Posted by martindwilson

i'm not sure wher the menu is in 2007 tho'
http://excel2007tips.blogspot.com/20...xcel-2007.html

It's on the developer tab!

**bmw30csl** · 05-13-2009, 09:54 AM

Thats a great help lads - thanks

**Simon Lloyd** · 05-13-2009, 12:56 PM

If we have solved your original query please mark your thread solved by going to your first post in this thread>Edit>Go Advanced then at the top near the title you will see a prefix dropdown change this to solved and click save!