+ Reply to Thread
Results 1 to 2 of 2

Need to move code and forms to different workbook.

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Need to move code and forms to different workbook.

    Is it possible to copy and pasy all cody forms and modules to a new workbook?
    Last edited by superchew; 03-15-2015 at 06:36 PM.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Need to move code and forms to different workbook.

    If you are familiar with the Visual Basic Editor then you are familiar with the project explorer window, which lists all your sheets and modules and user forms. If you have both workbooks open you can left click and drag a module from one workbook to the next and it will copy it into the new workbook, same thing with forms. With sheet code you probably have to just copy and paste the actual code. I don't have any sheet code handy right now to experiment on, there may be an easier way.

+ 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. VBA code to move workbook from one location to another
    By Stevo56 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-05-2014, 11:19 AM
  2. Need code to move a row of data from one workbook to another.
    By SLIDE1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2013, 01:33 PM
  3. Code needed to move info. from one workbook to another.
    By SLIDE1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2013, 07:29 AM
  4. [SOLVED] Can vba be used to move code to a new workbook?
    By Xaos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 03:33 PM
  5. VBA Code to Copy and Move Closed Workbook
    By kozman2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 09:36 AM

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