+ Reply to Thread
Results 1 to 3 of 3

Copy a sheet to a new book, perform action on new sheet but make new sheet invisible

  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Copy a sheet to a new book, perform action on new sheet but make new sheet invisible

    I want to copy sheet1 to a new workbook. I want to perform an action on the new workbook, however I do not want to see it. How can this be done. The below automatically activates the new book after i copy which is NOT what I want.

    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Copy a sheet to a new book, perform action on new sheet but make new sheet invisible

    Ok, this works to keep the focus on the original workbook, but the new one still shows up in the toolbar. How can I keep the new one completely invisible?

    HTML Code: 

  3. #3
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Copy a sheet to a new book, perform action on new sheet but make new sheet invisible

    Hi -

    Try;
    Please Login or Register  to view this content.
    event

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to make a sheet invisible?
    By sumesh56 in forum Excel General
    Replies: 3
    Last Post: 04-02-2013, 08:59 PM
  2. [SOLVED] Repeated action - shorten macro - copy from each sheet to summary sheet
    By sans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-07-2012, 11:37 AM
  3. [SOLVED] Perform Action Without Switching To Sheet
    By splendidus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2012, 07:23 AM
  4. How to copy sheet to new book without sheet module code?
    By MelinaT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2011, 11:52 AM
  5. Macro to copy sheet from closed work book and overwrite if sheet already exists
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-23-2009, 06:36 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