Group/Un-group Columns through buttons using VBA

Hi,

I have grouped my columns from "D" to "U", but I want to control them through button. If you click BUTTON1 placed in column "C", it should group them if they are un-grouped, or un-group them if they are grouped.

Can we control this through Macro. Below is link to the Excel file.

https://www.dropbox.com/s/9sinkgpa21...mple.xlsm?dl=0

Many Thanks

Thanks a million! This was quick and solved my problem. Thank you so so much.

Just one more thing, I have got 3 images on first row, when my columns expand, the images also moves to very far end, is there anyway by which I can keep the images in center all the time? When grouped or un-grouped, they should maintain their center position?

Many Thanks

Do you have any idea or any syntax in mind which I can play with? I can change the positions if you can give me an example line of code with proper syntax, I probably could work around on it, if its easy for you.

Thanks again.

How can I do this with Drop Down list in C column, Because I have 2 groups

Please Login or Register  to view this content.