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
|
|||
|
|||
How to copy a workbook so the buttons run the macros?
a.xcl has lots of macros and lots of buttons.
If I copy a.xcl as b.xcl and move a.xcl to a different folder and run eg. macro1 from the button in b.xcl I get an error message: a.xcl/macro1 not found. How can I copy a workbook so the buttons will run the macros in that workbook rather than looking for the macros in the original workbook? |
#2
|
|||
|
|||
You obviously know how to assign a macro to a button. Just do that again
and select the macro that is in that workbook. HTH Otto "-" wrote in message om... a.xcl has lots of macros and lots of buttons. If I copy a.xcl as b.xcl and move a.xcl to a different folder and run eg. macro1 from the button in b.xcl I get an error message: a.xcl/macro1 not found. How can I copy a workbook so the buttons will run the macros in that workbook rather than looking for the macros in the original workbook? |
#3
|
|||
|
|||
|
#5
|
|||
|
|||
In article ,
says... Emory What I would do in that case is remove the macros altogether from that(those) workbooks and instead put them all in your Personal.xls workbook. Then setup one file with all the buttons and each macro is assigned to its respective button. That way, when you copy the file, the macro assignments don't have to be changed. HTH Otto Otto, thanks for your thoughts. This is a good workable method. Emory "Emory Richter" wrote in message om... In article , says... You obviously know how to assign a macro to a button. Just do that again and select the macro that is in that workbook. HTH Otto "-" wrote in message om... a.xcl has lots of macros and lots of buttons. If I copy a.xcl as b.xcl and move a.xcl to a different folder and run eg. macro1 from the button in b.xcl I get an error message: a.xcl/macro1 not found. How can I copy a workbook so the buttons will run the macros in that workbook rather than looking for the macros in the original workbook? Otto The problem is I have hundreds of macros in the workbook and it is copied each month to replace the contents with new inventory info. Reassigning the macros to the buttons is what I am trying to avoid. Emory |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy sheet to new workbook | Tim | General Discussion | 5 | April 28th, 2005 02:00 PM |
copy a workbook without any data being copied | Rusty | Setting up and Configuration | 0 | November 4th, 2004 01:59 AM |
copy data from workbook to workbook | Robert N | Worksheet Functions | 1 | October 1st, 2004 11:03 AM |
Return to previous workbook | Andy Sandford | Worksheet Functions | 10 | February 28th, 2004 05:16 PM |