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?

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?

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

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
"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

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