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
Bookmarks