+ Reply to Thread
Results 1 to 3 of 3

Toggling Between Workbooks

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Toggling Between Workbooks

    The code below is not executing correctly due to the fact that I believe I am not toggling between the workbook where I am executing the code (wbCodeBook), and where I am copying the gPA worksheet (wbResults). Any ideas where I am going wrong?

    Please Login or Register  to view this content.
    Thanks in advance....

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Toggling Between Workbooks

    scm24
    you could copy the sheet to the other workbook with
    Please Login or Register  to view this content.
    then rename sheet
    Please Login or Register  to view this content.
    hope it helps
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Toggling Between Workbooks

    Here's some code I found.
    I Don't know if this is what you want, but you can try this.

    Insert this code into each workbook that you want to toggle between.
    Create a button at the top of a sheet within each book. Assign the macro placed into each book to the button. This will allow you to toggle.

    Please Login or Register  to view this content.
    HTH's

    BDB

+ Reply to Thread

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.6.0 RC 1