copy and paste macros

D

Drew

I have a workbook that has several macros in it. I created anothe
similar workbook that uses the old workbook and macros as the basi
platform for the new workbook. I copied and pasted the old macros t
the new workbook. When I ran the macros after creating the ne
workbook, everything worked fine. I emailed the program to my hom
computer, and when I try to run the macros there, I get a run-tim
error. What it looks like to me is the new workbook is trying t
access the old workbooks macros. That is why it works on the compute
I created the workbook on and not on my home computer, where I do no
have a copy of the old workbook.

Is there anything short of re-writing the macros that will solve this?

Thanks in advance

Dre
 
L

Lady Layla

email old workbook to home?


: I have a workbook that has several macros in it. I created another
: similar workbook that uses the old workbook and macros as the basic
: platform for the new workbook. I copied and pasted the old macros to
: the new workbook. When I ran the macros after creating the new
: workbook, everything worked fine. I emailed the program to my home
: computer, and when I try to run the macros there, I get a run-time
: error. What it looks like to me is the new workbook is trying to
: access the old workbooks macros. That is why it works on the computer
: I created the workbook on and not on my home computer, where I do not
: have a copy of the old workbook.
:
: Is there anything short of re-writing the macros that will solve this?
:
: Thanks in advance
:
: Drew
:
:
: ---
:
:
 
P

PegL

If you're running the macros via a toolbar button, you
can modify the toolbar button to run the macro in the
current workbook. You might also check the macros to see
if they reference the old workbook name anywhere.
 
Top