+ Reply to Thread
Results 1 to 5 of 5

button to toggle hide/unhide columns

  1. #1
    Registered User
    Join Date
    03-01-2013
    Location
    NYC
    MS-Off Ver
    Excel 2013
    Posts
    19

    button to toggle hide/unhide columns

    Hi,
    I'm totally new to this, so please explain the whole process (I know I'm asking a lot),
    I want to create button at the top of a column that by pressing it I could hide/show few columns to the left of the column with a button.
    Thanks

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: button to toggle hide/unhide columns

    Hi,

    Use this code. Which basically hides columns C,D,E & F and then unhides D & E. Change the code to suit your requirement.

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  3. #3
    Registered User
    Join Date
    03-01-2013
    Location
    NYC
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: button to toggle hide/unhide columns

    Hi and thanks,
    Sorry but I'm truly an ignorant. Could you give me the whole code? SHould I first insert Active X control TOGGLE BUTTON?
    Thanks again,
    dbuff

  4. #4
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: button to toggle hide/unhide columns

    Hi,
    You are there. Insert the toggle button from active X tool box and then double click on that toggle button.

    Now paste the code below the line Private Sub ToggleButton1_Click(). Hope this helps.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-01-2013
    Location
    NYC
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: button to toggle hide/unhide columns

    Thanks much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1