Results 1 to 2 of 2

How to generate a list of all Sheets within a workBOOK

Threaded View

xtreme4u How to generate a list of all... 09-30-2014, 05:00 PM
JBeaucaire Re: How to generate a list of... 09-30-2014, 05:39 PM
  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    calgary, canada
    MS-Off Ver
    2007
    Posts
    10

    How to generate a list of all Sheets within a workBOOK

    Hi All,

    Tried researching this but for some reason can't find it. I have a workbook with numbered sheets. I would like to do two things with this.

    1. Generate a list of all the sheet names in the order that they appear.

    2. Hide the sheets that i don't wish to look at anymore. Currently I'm using a macro that i will post below. The problem is that i have to update the macro with the name of every sheet as it is added. I'm hoping that with the list we will generate from question 1 there is an easier way of achieving the hide and show feature.

    Private Sub SHOWOLD_Click()
    Dim ws As Worksheet
    For Each ws In Sheets(Array("PO's 2013", "Expences 2013", "1a (2013)", "1b (2013)", "WSOOA (2013)", "PO's 2012", "1a (2012)", "1b (2012)", "WSOOA (2012)", "PO's 2011"))
        ws.Visible = True
    Next ws
    Sheets("old").Activate
    End Sub
    Last edited by JBeaucaire; 09-30-2014 at 05:36 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generate a pending list from multiple sheets
    By stevense28 in forum Excel General
    Replies: 11
    Last Post: 03-26-2014, 02:27 PM
  2. Replies: 5
    Last Post: 09-30-2012, 07:47 AM
  3. Need a VB code to generate sheets from a list of cells
    By Thanatos in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-07-2008, 08:14 AM
  4. Excel Generate List from Multiple Sheets
    By Scorpio in forum Excel General
    Replies: 5
    Last Post: 05-16-2008, 01:20 PM
  5. Generate list in separate workbook
    By PG Oriel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2006, 05:50 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