+ Reply to Thread
Results 1 to 9 of 9

Copying an Existing Macro From Worksheet To Another Worksheet View Code

  1. #1
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Copying an Existing Macro From Worksheet To Another Worksheet View Code

    Excel Gurus.....just out of curiosity I am inquiring whether there is a possibility to Insert a Macro present in Sheet1 to another Worksheet's View Code....
    as the worksheet is created at a later stage........and if this worksheet is created it has to copy the macro already present in Sheet1 to this worksheet named "My Client."

    Happy Day......

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Copying an Existing Macro From Worksheet To Another Worksheet View Code

    Hello
    Instead of copying this macro across sheets, you can use it in ThisWorkbook module
    Please Login or Register  to view this content.
    And it will work for all sheets..
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Copying an Existing Macro From Worksheet To Another Worksheet View Code

    ohh....great thank you Mr. Yasser.......your help is greatly appreciated......i will add reputation to you and close this....thank you......again....

  4. #4
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Copying an Existing Macro From Worksheet To Another Worksheet View Code

    but one problem is that it has go the following macro which the name matches to what you said..so how to go about this..
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Copying an Existing Macro From Worksheet To Another Worksheet View Code

    can this above code be changed to as workbook....please help

  6. #6
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Copying an Existing Macro From Worksheet To Another Worksheet View Code

    and what if I do not want this macro to work on a particular worksheet....so it will be a problem right.....as on other worksheets different shortcuts will intercept the macro?? any solution....

  7. #7
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Copying an Existing Macro From Worksheet To Another Worksheet View Code

    Hello Try this code
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    05-23-2017
    Location
    Bang, India
    MS-Off Ver
    MS Office 2007
    Posts
    221

    Re: Copying an Existing Macro From Worksheet To Another Worksheet View Code

    Great !!!!!!!!!!!!!!! thats exactly working like a charm......thanks for your valuable time on this......i am indebted to you........you saved so much of manual work.....) God be with you......yasser......

  9. #9
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Copying an Existing Macro From Worksheet To Another Worksheet View Code

    You're welcome Quivolt
    Glad I can offer some help for you

    Pleas mark the thread as solved

    Regards

+ 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. Replies: 1
    Last Post: 07-23-2016, 11:50 PM
  2. Replies: 8
    Last Post: 04-15-2014, 04:35 AM
  3. VBA code for copying a worksheet and pasting it as a new worksheet in Excel
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2012, 11:56 AM
  4. macro or vba code for copying and pasting data from one worksheet to another
    By jruiz13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2011, 10:05 AM
  5. Macro to create new worksheet with values from existing worksheet
    By SamBam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2011, 05:33 AM
  6. Question when Copying an Existing Worksheet
    By LL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Question when Copying an Existing Worksheet
    By LL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12: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