I have a "model" workbook that I use to create a new workbook for each member
in an organization. The Model workbook has one macro that is used to
validate the input data that the members will compile. However, the macro
points to the original macro using a "D:\...." reference instead of just a
reference to "ValidateData" in the new workbook. How can I make sure that
the reference to the macro in the copied workbook just points to the
"ValidateData" macro in the newly created workbook and not the macro in the
original workbook?

Thanks for the help!
--
Steve

Various ways which depends on how you are calling the macro code,

try ThisWorkbook

or post code

--

Regards,
Nigel
(E-Mail Removed)



"sbweid" <(E-Mail Removed)> wrote in message
news:7E2E6D37-EBDF-44B1-8F44-(E-Mail Removed)...
>I have a "model" workbook that I use to create a new workbook for each
>member
> in an organization. The Model workbook has one macro that is used to
> validate the input data that the members will compile. However, the macro
> points to the original macro using a "D:\...." reference instead of just a
> reference to "ValidateData" in the new workbook. How can I make sure that
> the reference to the macro in the copied workbook just points to the
> "ValidateData" macro in the newly created workbook and not the macro in
> the
> original workbook?
>
> Thanks for the help!
> --
> Steve