Macros for checkboxes
Min
another way to hide an individual column.
Creat a list of the cols to hide, say on a new sheet. I used COls E to H
On the sheet you want to operate add a combo box, I linked it to A1. then I
assigned this macro.
Sub HideCol()
c = Range("A1") + 3
Columns(c).EntireColumn.Hidden = Not Columns(c).EntireColumn.Hidden
End Sub
Maybe this will help another time
Peter
|