If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Move/Copy Worksheet with Macros
When I copy a set of worksheets from one workbook to another the macros don't
follow. Let me Explain: I copy worksheets from workbook A into workbook B and close workbook A. Then from workbook B I select the command button to run a macro. What happens is workbook A opens again and runs the macro. If I break the link with workbook A in workbook B using Edit/Links the command button doesn't do anything. How can I move the worksheets into the new workbook and have them behave as they did originally? Thanks |
#2
|
|||
|
|||
Move/Copy Worksheet with Macros
A tiny trick:
Rather than copy sheets from Book A to Book B, make a "Book B" by making a copy of Book A, removing material you don't want in B, adding material you do want in B and then calling the modifed copy Book B. The point is that by copying Book A, you will also copy all the included macros. -- Gary''s Student - gsnu200907 "Hansplay" wrote: When I copy a set of worksheets from one workbook to another the macros don't follow. Let me Explain: I copy worksheets from workbook A into workbook B and close workbook A. Then from workbook B I select the command button to run a macro. What happens is workbook A opens again and runs the macro. If I break the link with workbook A in workbook B using Edit/Links the command button doesn't do anything. How can I move the worksheets into the new workbook and have them behave as they did originally? Thanks |
#3
|
|||
|
|||
Move/Copy Worksheet with Macros
Thanks for the quick response. The only problem with that is "Book B" also
contains macros that I need to keep. I am combining two workbooks, each containing several macros. Thanks. "Gary''s Student" wrote: A tiny trick: Rather than copy sheets from Book A to Book B, make a "Book B" by making a copy of Book A, removing material you don't want in B, adding material you do want in B and then calling the modifed copy Book B. The point is that by copying Book A, you will also copy all the included macros. -- Gary''s Student - gsnu200907 "Hansplay" wrote: When I copy a set of worksheets from one workbook to another the macros don't follow. Let me Explain: I copy worksheets from workbook A into workbook B and close workbook A. Then from workbook B I select the command button to run a macro. What happens is workbook A opens again and runs the macro. If I break the link with workbook A in workbook B using Edit/Links the command button doesn't do anything. How can I move the worksheets into the new workbook and have them behave as they did originally? Thanks |
Thread Tools | |
Display Modes | |
|
|