+ Reply to Thread
Results 1 to 2 of 2

Can a macro copy a hidden worksheet?

  1. #1
    Registered User
    Join Date
    03-10-2015
    Location
    canada
    MS-Off Ver
    2007
    Posts
    29

    Can a macro copy a hidden worksheet?

    I have this macro which currently copies the template sheet to be used as a template for a new month.

    I would like to hide this sheet and still have it work, but it doesn't work when I hide it. Is there a way to do this?


    Sub CopyandPaste()
    On Error Resume Next
    Windows("Test 2017.xlsm").Activate
    Sheets("Template").Select

    Sheets("Template").Copy Before:=Workbooks("Test 2017.xlsm").Sheets("Yearly Data")

    End Sub

  2. #2
    Registered User
    Join Date
    03-10-2015
    Location
    canada
    MS-Off Ver
    2007
    Posts
    29

    Re: Can a macro copy a hidden worksheet?

    Already figured it out, sorry lol

+ 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] Macro to copy a hidden worksheet to an existing workbook then rename.
    By namy77 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2017, 12:43 PM
  2. [SOLVED] Macro with hidden worksheet
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2013, 08:49 AM
  3. Automatically copy date from DTpicker and paste into hidden worksheet
    By msexceljones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2012, 07:08 PM
  4. Replies: 0
    Last Post: 09-13-2012, 11:10 AM
  5. How to copy a hidden sheet in a workbook and paste it into a new worksheet and renaming it
    By kvs.somashekhar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2012, 08:20 AM
  6. copy worksheet that is hidden and rename it using a userfom
    By iscar_marius in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-17-2009, 06:03 AM
  7. [SOLVED] How do I NOT copy hidden rows to a new worksheet?
    By Steve in forum Excel General
    Replies: 3
    Last Post: 03-03-2006, 01: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