+ Reply to Thread
Results 1 to 3 of 3

Toggle Hide/ Show Named Ranges

  1. #1
    Forum Contributor
    Join Date
    11-16-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    405

    Question Toggle Hide/ Show Named Ranges

    Hi guys,

    I have named ranges listed from columns A:H whos rows vary in size weekly.
    These named ranges are defined by borders - start at A3, go down rows until bottom border is found - extend selection to column H and name range as the value found in the top left cell of that range.
    offset 1 cell from the bottom border and set that as the top border for the next range then continue the same process until all ranges are found and named.
    I want to create a macro that will toggle between hiding and showing named ranges.

    The workbook is designed as a report viewer - which is to be embedded into IExplorer on an internal intranet site. Therefore there needs to have a fair bit of functionality and hence the reason why i need to be able to toggle the ranges.

    I have a seperate worksheet "Data" that has a list of all the named ranges and the order they appear, in the column next to these named ranges is a 1 or 0 - which i want to use to define which ranges toggle what..
    I.e. all those ranges that have a 1 next to them allows them to toggle any range below that have a 0 next to them until the next 1 is reached.
    The Ranges with 0 cant be toggled.

    Is this possible??
    Regards
    Last edited by jordan2322; 01-10-2012 at 06:58 PM.

  2. #2
    Forum Contributor
    Join Date
    11-16-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    405

    Re: Toggle Hide/ Show Named Ranges

    ****bump****

  3. #3
    Forum Contributor
    Join Date
    11-16-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    405

    Re: Toggle Hide/ Show Named Ranges

    No Suggestions or Ideas from anyone?

+ 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