Excel VBA code

[pb01081995]

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.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel VBA code
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.