Need code to hide columns when button pressed

[payalbansal01]

Hi, Can you please help me with this code?

Hide specified columns:
1. Click a button in excel
2. Message prompt will pop up “Which columns do you want to hide?” with a text box to type in the answer
3. User types in a range of consecutive columns (ex: A:C). Clicks OK.
4. The specified columns are hidden and a message box pops up to say “Done!”
5. If user clicks the button again and enters the same range or subset of the range (which is already hidden), another message box will pop up to say 6. “It’s already hidden!” However, if it is an overlapping range (ex: C:E, where col C is already hidden), only the unhidden part of the range will be hidden (ex: D:E).

Thanks in advance.

[dangelor]

Attach this code to a button...

Please Login or Register  to view this content.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Because it is your first post I will provide the link: https://www.mrexcel.com/board/thread...-code.1174682/

However, please take the time to review our rules before you continue posting.

[payalbansal01]

Thank you so much.

[Croweater]

It works for me.

How about telling us what you did with the code, how you ran the macro, what you put as input to the prompt and why you think it's not working?

Saying it is 'not working', and asking someone who helped you to 'check again' is not a good response IMO.

[dangelor]

It seems I missed your reply, payalbansal01... care to repost it?

[6StringJazzer]

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Excel VBA code" is not a good title. I have updated it for you this time because you are a new member. --6StringJazzer

[Croweater]

About time the rules were updated.

"It does not work" as a response, should be against the rules, especially when the code provided actually DOES work.

[6StringJazzer]

"It does not work" as a response, should be against the rules, especially when the code provided actually DOES work.

Moderator's note: Just in case anyone is confused, this comment refers to post #4, which has been updated and no longer says the solution doesn't work.

BTW here is my standard response when someone says something doesn't work:



Please explain what "doesn't work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?