+ Reply to Thread
Results 1 to 5 of 5

Create New Workbook, Copy Worksheets, But Hide One of Them - Nearly There!

  1. #1
    Registered User
    Join Date
    07-29-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    11

    Create New Workbook, Copy Worksheets, But Hide One of Them - Nearly There!

    Hi All,
    Excel 2007
    I have a 'Control' workbook which has an input worksheet and a data worksheet for each country.
    By clicking a button it executes and creates a new Workbook and copies ino it that countries input worksheet and data worksheet, and places it to a file location, which is specified by a cell in the workbook.

    Everything works ok, but i do not know how to hide the data worksheet in the new workbook, any ideas?

    Here is my code:

    Please Login or Register  to view this content.
    Last edited by goodwinh; 08-15-2011 at 12:26 PM.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Create New Workbook, Copy Worksheets, But Hide One of Them - Nearly There!

    Hi goodwinh and welcome to the forum. Please take a moment to read the forum rules (located in my signature) and wrap code tags around your code as per Rule #3. Once you do that, someone will be able to help you.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Registered User
    Join Date
    07-29-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Create New Workbook, Copy Worksheets, But Hide One of Them - Nearly There!

    thanks for the tip Mordred.

  4. #4
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    PA
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Create New Workbook, Copy Worksheets, But Hide One of Them - Nearly There!

    Hi,

    Maybe This will help?

    Please Login or Register  to view this content.
    Thank You, Mike

    Some Helpful Hints:

    1. New members please read & follow the Forum Rules
    2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
    3. If you are pleased with a solution mark your post SOLVED.
    4. Thank those who have help you by clicking the scales at the top right of the post.

    Here...

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Create New Workbook, Copy Worksheets, But Hide One of Them - Nearly There!

    Why don't you create a proper template workbook?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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