+ Reply to Thread
Results 1 to 11 of 11

Inserting a worksheet into another workbook loses its macro in the journey

Hybrid View

Bill Allen Inserting a worksheet into... 08-03-2014, 10:09 AM
HaHoBe Re: Inserting a worksheet... 08-03-2014, 10:12 AM
Bill Allen Re: Inserting a worksheet... 08-03-2014, 10:52 AM
HaHoBe Re: Inserting a worksheet... 08-03-2014, 10:59 AM
Bill Allen Re: Inserting a worksheet... 08-03-2014, 07:16 PM
HaHoBe Re: Inserting a worksheet... 08-03-2014, 11:00 PM
Bill Allen Re: Inserting a worksheet... 08-03-2014, 11:10 PM
HaHoBe Re: Inserting a worksheet... 08-03-2014, 11:19 PM
Bill Allen Re: Inserting a worksheet... 08-03-2014, 11:23 PM
HaHoBe Re: Inserting a worksheet... 08-03-2014, 11:40 PM
Bill Allen Re: Inserting a worksheet... 08-03-2014, 11:15 PM
  1. #1
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Inserting a worksheet into another workbook loses its macro in the journey

    Hi, Bill Allen,

    please have a look at Forum Rule #3 and add code-tags to your procedure. I´d expected that code to be located in a standrad module, not behind a worksheet.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  2. #2
    Registered User
    Join Date
    04-14-2014
    Location
    Laguna Niguel, CA
    MS-Off Ver
    Version 2404
    Posts
    44

    Re: Inserting a worksheet into another workbook loses its macro in the journey

    Are you saying that some worksheets containing macros can be inserted into other workbooks but some cannot due to the specific coding of the macro?

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Inserting a worksheet into another workbook loses its macro in the journey

    Hi, Bill Allen,

    what I wanted to say: you posted the macro that gets lost according to you but not the way you copy (via Macro or by hand) nor the extensions of the files concerned.

    Ciao,
    Holger

+ 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] Inserting Cells loses Formula
    By Jennsy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-22-2013, 05:07 AM
  2. VB code error when workbook loses focus
    By Protiusmime in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-12-2008, 12:43 AM
  3. Inserting a worksheet into an open workbook via VBA code
    By manillla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2005, 09:05 PM
  4. INserting a worksheet from one workbook to another workbook
    By Billy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-31-2005, 08:05 PM
  5. Inserting a worksheet from external workbook
    By Hall in forum Excel General
    Replies: 2
    Last Post: 02-23-2005, 06:06 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