Results 1 to 5 of 5

Hide/unhide sheets as per list in named range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Hide/unhide sheets as per list in named range

    Hi
    I wonder can help me. I have the following sheets within my workbook:

    Interface
    properties M60
    properties M61
    properties M62
    properties M64
    properties general

    On sheet "properties general" in cells G1 to G7 I have the following values:

    G1 ---- Sheets (properties)
    G2 ---- All sheets

    G3 ---- properties M60
    G4 ---- properties M61
    G5 ---- properties M62
    G6 ---- properties M64
    G7 ---- properties general


    Now I have created a dynamic damed range (Sheet_count_DYNAMIC_Properties). This named range essentially covers G3 to G7 (highlighted in green).

    My question is, how to code in VBA to hide all sheets declared in named range Sheet_count_DYNAMIC_Properties???. I have attached example xls.
    Any help is much appreciated.
    Attached Files Attached Files
    Last edited by rain4u; 02-18-2012 at 01:18 PM.

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