macro to selectively hide columns for printing

[elevdown]

Hi,
I have a worksheet range A1:O92.
I want the user to be able to run a macro that will allow them to select which columns are to be printed (or not printed).
I always want all of the rows to be printed.
I am assuming the best way to do this is to "hide" the columns that will not be printed.
Can someone help me with code that will allow the macro to ask the user to individually select columns: A thru O to be hidden then press "Enter"?
Once I have the worksheet set up with the proper columns shown I can finish the macro for printing out the selected columns.
Thank you for any input!

[RaulRodriguez]

So why can't the user click on the columns and manually hit hide then print? How much time and effort are your really saving?

[elevdown]

Perfectly good question ... but there are other issues with the worksheet and the users are not familiar with excel at all.
My current worksheet is formatted (my another macro) such that when you click any cell (or column heading) it highlights the whole row (or all of the columns) ... which means if you click on a column to hide it, it will highlight all of the columns and they will all disappear. I do have a command button to turn this feature off but I didn't want the user to have to make that decision.
My macro would also incorporate defeating this "highlighting the whole row" (worksheet event) before it asks the user which columns to hide.
Thanks again!

[RaulRodriguez]

The following code will hide the columns where the user has click while holding the Control Key. The last line re-opens the hidden columns so the process can be repeated; you will have to stick your printing code after the For Next loop and before the las line. Otherwise you may want to add check boxes for column selection. Either way the user must do "something".

Please Login or Register  to view this content.

[jaslake]

Hi elevdown
I prefer to use a UserForm for this type of User Interface...see attached.

[xladept]

Hi elevdown,

Here's another option:

Please Login or Register  to view this content.

[elevdown]

Thanks for the replies ... these are 3 great ideas.
RaulRodrigues - this was the original direction I was headed - thanks.
jaslake - I never thought of this (not familiar at all with userforms but I think that is a great idea - I will have to learn more about that - thanks to you also!
xladept - this works very well also - I should be able to incorporate this into my macro for printing desired columns - thanks very much to all!

[xladept]

Hi elevdown,

Thanks for the response - glad it's worked out!