I have been digging through the forums and can't find what I am looking for.
I have a very large spreadsheet (Columns A:AK right now...still growing) and I would like to hide columns based on my selection from a ListBox I have in place. Is this possible?
I have already created Macros that will do this, but I can't assign buttons because when you hide the columns you can't see the button to unhide the columns again. :/
My ListBox has the names:
HideRevenue
ShowRevenue
HideMax
ShowMax
HideVolume
ShowVolume
The columns I would like to hide/unhide with each selection are:
Revenue = I:L
Max = M:S
Volume = T,X:Z,AF
I am not new to Excel, but I am new to VBA which is what I have been trying to use to make this happen. I'm sure there is a way, but can't find it or figure it out on my own.
Thanks for the help.
Bookmarks