Macro for a button

Hi,

I'm wondering if I can use a macro to make a button do different things with each click. I'm wanting to hide/unhide different columns. At the moment I can get it to hide G:BB and then unhide them with the second click. I would prefer it to work as follows

1st click - hide columns G:BB
2nd click - hide additional columns C and E
3rd click - unhide the hidden columns

I have seen a few posts with private subs so I'm not sure if this is an easier way of doing this but I don't know how to use them.

Any help would be greatly appreciated.

Thanks

Thanks for your help. I am creating something for multiple users and I want it to be as simple as possible to use. There are also multiple sections that will have buttons to perform the same operation. It seems to work although with the second click it hides range C:E but I don't want column D to be hidden. I would like it to leave columns D & F visible. I did play around with changing it to C:C,E:E but it didn't like it the way I changed it. Thanks again

Didn't really know what I was doing but seem to have got it sorted by playing around with it. Used the following code

Sub Hide_Unhide()
If ActiveSheet.Columns("G:BB").Hidden = True And ActiveSheet.Columns("C:C").Hidden = True And ActiveSheet.Columns("E:E").Hidden = True Then
ActiveSheet.Columns("G:BB").Hidden = False
ActiveSheet.Columns("C:C").Hidden = False
ActiveSheet.Columns("E:E").Hidden = False
Exit Sub
End If


If ActiveSheet.Columns("G:BB").Hidden = False Then
ActiveSheet.Columns("G:BB").Hidden = True
Else
ActiveSheet.Columns("C:C").Hidden = True
ActiveSheet.Columns("E:E").Hidden = True
End If

End Sub