+ Reply to Thread
Results 1 to 3 of 3

VBA for HIDE/UNHIDE Colum when press double click

  1. #1
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    412

    VBA for HIDE/UNHIDE Colum when press double click

    Hello Team

    We want a VBA or Macro for my worksheet.. where we double click in J1 Cell (Cell Text Show Detail) then HIDE colum D to Colum I

    & Cell Text Value Show Details change to Hide Details



    & When again we double click on Cell Value J1 then unhide Colum D to Colum I & Cell Text Value Hide Details change to Show Details

    Thanks in Advance

    Santosh

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: VBA for HIDE/UNHIDE Colum when press double click

    Hi
    Cut and paste this code behind the worksheet in question. Right click on the tab name and select "View Code", then paste the code and close the view.
    Then double click on J1 to hide or unhide columns D to I:

    Please Login or Register  to view this content.
    Good luck.
    Tony

  3. #3
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    412

    Re: VBA for HIDE/UNHIDE Colum when press double click

    Hi Tony ur code working fine as per my requirement but we also want to change Cell Value JI ... Show Details to Hide Details & Hide Details to Show Details so that we can easily tell any one that now u unhide & now u hide..

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy double-clicked cell to next empty row in different sheet with each double-click
    By erhathaway in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-25-2013, 12:06 AM
  2. Disable Hide/Unhide from Format, and right click on Row and Column
    By lejlasehic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2013, 07:05 AM
  3. [SOLVED] need to hide / unhide cells with single click
    By SBURTON in forum Excel General
    Replies: 2
    Last Post: 09-25-2012, 03:00 PM
  4. click - hide/unhide column
    By sqoo in forum Excel General
    Replies: 7
    Last Post: 11-28-2011, 04:48 PM
  5. Click on graph bar to execute a double-click in a pivot table cell
    By Bill_F_Lyle@fpl.com in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-02-2005, 09:05 PM

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