+ Reply to Thread
Results 1 to 7 of 7

My Macro will not work when I copy to a new module

  1. #1
    Forum Contributor
    Join Date
    03-31-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    211

    My Macro will not work when I copy to a new module

    I have the same macro that I have running in the 1st tab E-O1 and I copied and pasted it in to the other tabs but the others do not work. What am I doing wrong? If to go to the 1st tab E-O1 row 3010 and click on cells 1HIJK you will see the 4 digit numbers go up a row. Now go to any of the other sheets and try to do the same and none of them work. Why?

    Thank you!!!

    https://app.box.com/s/53eby24nqylwjnu0ehlz
    Last edited by Larbec; 05-30-2014 at 12:59 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: My Macro will not work when I copy to a new module

    You must post your workbooks directly to the forum.
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: My Macro will not work when I copy to a new module

    As a party of one, I won't download from a site that wants to install software on my computer. I'll look if you put it on box.net.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Contributor
    Join Date
    03-31-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: My Macro will not work when I copy to a new module

    I tried through the advance tab and it says error, file may be too big, let me sign up for box

    https://app.box.com/s/53eby24nqylwjnu0ehlz
    Last edited by Larbec; 05-30-2014 at 12:59 AM.

  5. #5
    Forum Contributor
    Join Date
    03-31-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: My Macro will not work when I copy to a new module

    Can I get a step by step on how to copy and paste a Macro in my book and then get it to run. I know formulas well and learning Macros Here are a couple snap shots as to what I am looking at to the left of my code


    Module.jpgAll My Books.jpg

  6. #6
    Forum Contributor
    Join Date
    03-31-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: My Macro will not work when I copy to a new module

    I will move to a different forum since no one seems to know how to do this. Thanks for trying

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

    Re: My Macro will not work when I copy to a new module

    Hi, Larbec,

    I encountered two reasons: the module should only be in ThisWorkbook (thatīs where Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) belongs if I remember correctly). And if you really copied it to other sheets you would need to use a different event for the sheets, disable the ThisWorkbook-event and make sure that the sheet names are altered to suit in order to make the code work.

    Ciao,
    Holger
    Last edited by HaHoBe; 05-31-2014 at 01:59 AM.
    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

+ 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] AND formula does not work inside the macro module
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2013, 08:49 PM
  2. How do I copy a new module to 200 workbooks with a macro?
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 05:05 PM
  3. [SOLVED] How do I copy a new module to 200 workbooks with a macro?
    By Patrick Young in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  4. [SOLVED] How do I copy a new module to 200 workbooks with a macro?
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 05:05 AM
  5. How do I copy a new module to 200 workbooks with a macro?
    By Patrick Young in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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