Macro Excel Checkbox Hide Column in Sheet?

March 18th, 2010
  • in Sheet i have Data i want to hide column AQ to DK went i tick in check box it should hide & went untick shound unhide

    formular to hide row
    Sub hiderow()

    If Rows("5").RowHeight = 0 Then
    Rows("5").Hidden = False
    Else
    Rows("5").Hidden = True
    End If
    End Sub '1

    i want to hide only column AQ:DK


    please help
    thank you advance


  • Assume you used checkbox from the control toolbar, after the drawing a checkbox on the sheet, click view code button
    Put the following code in the Sheet module where the checkbox is located
    Private Sub CheckBox1_Click()
       If CheckBox1.Value = False Then
          Columns("AQ:DK").Hidden = False
       Else
          Columns("AQ:DK").Hidden = True
       End If
    End Sub
    Please contact for more details







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Macro Excel Checkbox Hide Column in Sheet? , Please add it free.

    Posted in patrickdeuel.com | edit

    Transformers: Scanner to Communications Hub
    Get Relief For Baby’s Eczema