Hi,
Yeah I'd say the control checkbox would be best to use. To do it insert the checkbox via the control toolbar and then double click it whilst in design mode.
Paste the following code:
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
Columns("H").EntireColumn.Hidden = True
Columns("M").EntireColumn.Hidden = True
Else
Columns("H").EntireColumn.Hidden = False
Columns("M").EntireColumn.Hidden = False
End If
End Sub
Now when you exit design mode and click the checkbox you'll see columns H and M are hidden. When you uncheck it they will be displayed again.
Thanks
Bookmarks