+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    02-07-2010
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    13

    Grouping Worksheets

    Hi,

    I am a newbie on this forum & this is my 1st post

    I want to group a worksheet with another & save it as grouped so that after I re-open the workbook those sheets are grouped as default. How to do it ?

    Is it possible ? Please Help

    Sorry if reposted, please give me the link to that forum if possible.

    Thanks in advance.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944

    Re: Grouping Worksheets

    You could place this code in the Open event of the Thisworkbook object.

    Change the name of the sheets to be grouped

    Code:
    Private Sub Workbook_Open()
    
        Sheets(Array("Sheet1", "Sheet2")).Select
        
    End Sub
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-07-2010
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    13

    Re: Grouping Worksheets

    Hey Andy...thanks a lot man

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.2.0