+ Reply to Thread
Results 1 to 3 of 3

Hide/Unhide Range of Cells using Hyperlink

  1. 04-24-2014, 10:39 AM #1
    Makkers31
    Makkers31 is offline
    Registered User
    Join Date
    04-24-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    2

    Hide/Unhide Range of Cells using Hyperlink

    Hi Guys,

    I'm wondering if it is possible to use a hyperlink in excel to hide and unhide a range of cells.

    Basically I want to be able to click on the text in a cell (A1), and hide the following 10 rows beneath this one (A2-A11). Clicking the text again would unhide the 10 rows. Is this at all possible or just another crazy excel dream?!

    Any help would be greatly appreciated!

    Thanks,
    Makkers
    Reply With QuoteRegister To Reply
  2. 04-25-2014, 10:47 AM #2
    natefarm
    natefarm is offline
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Hide/Unhide Range of Cells using Hyperlink

    Put this in the code behind the worksheet containing the hyperlink.

    Please Login or Register  to view this content.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
    Reply With QuoteRegister To Reply
  3. 04-25-2014, 11:13 AM #3
    Makkers31
    Makkers31 is offline
    Registered User
    Join Date
    04-24-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Hide/Unhide Range of Cells using Hyperlink

    Amazing! Works perfectly - Thanks very much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide/Unhide Cells based on a Date Range
    By burdettejj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2014, 05:01 AM
  2. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  3. [SOLVED] Hide unhide range
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2013, 10:35 AM
  4. how to unhide & hide sheets using hyperlink.
    By aliimrankhan2009 in forum Excel General
    Replies: 3
    Last Post: 09-07-2012, 03:22 AM
  5. [SOLVED] [SOLVED] create button that can hide/unhide sheets and hyperlink...
    By Helen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2005, 12:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1