Macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alish - 07 Mar 2008 10:33 GMT

All,
I have a template that I put together a marco in. Whenever I send it to my
colleage the macro does not work. How do I make the macro travel with the
template or gets copied whenever I copy the template into other drives.
Thanks.

Reply to this Message

Dave Peterson - 07 Mar 2008 11:37 GMT

The macro lives in the workbook/template--so if you shared the workbook/template
as a normal .xls or .xlt or .xla workbook/template, then the macro made it
there.

I'd ask the recipient if they allow macros to run--tell them to check their
security settings.

If you have more questions, be sure to share the version of excel that they're
running.

> All,
> I have a template that I put together a marco in. Whenever I send it to my
> colleage the macro does not work. How do I make the macro travel with the
> template or gets copied whenever I copy the template into other drives.
> Thanks.

Signature

Dave Peterson

Reply to this Message

alish - 07 Mar 2008 12:05 GMT

> The macro lives in the workbook/template--so if you shared the workbook/template
> as a normal .xls or .xlt or .xla workbook/template, then the macro made it
[quoted text clipped - 11 lines]
> > template or gets copied whenever I copy the template into other drives.
> > Thanks.

Reply to this Message

alish - 07 Mar 2008 12:07 GMT

Dave, I created a user friendly macro by putting a button for it right on the
sheet. So whenever the recipient clicks on it it give some error message. I
check the code are there with the workbook. I just want everybody to use it.
Please advice.

Reply to this Message

alish - 07 Mar 2008 12:25 GMT

Dave, this is the error message it gives whenever the recipient tries to
click on the macro button: " 'PERSONAL.XLS' could not be found. Check the
spelling of the file name, and verify that the file location is correct."
Please advice. Thanks for your help.

Reply to this Message

Don Guillett - 07 Mar 2008 13:07 GMT

An easy way to create a personal.xls for the first time is to just record
ANY macro using personal.xls as the destination. Excel will create it for
you.

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Dave, this is the error message it gives whenever the recipient tries to
> click on the macro button: " 'PERSONAL.XLS' could not be found. Check the
[quoted text clipped - 22 lines]
>> > template or gets copied whenever I copy the template into other drives.
>> > Thanks.

Reply to this Message

Dave Peterson - 07 Mar 2008 14:21 GMT

The macro that is assigned to the button is located in your personal.xls
file--probably not the workbook with the button, right?

I think that the easiest fix is to delete that button (from the Forms toolbar)
and replace it with a commandbutton from the Control toolbox toolbar.

You'll have to move/modify your code so that it goes in the
"CommandButton1_Click()" event, but after you do that, it should work much
easier.

> Dave, this is the error message it gives whenever the recipient tries to
> click on the macro button: " 'PERSONAL.XLS' could not be found. Check the
[quoted text clipped - 20 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

alish - 07 Mar 2008 16:23 GMT

Thanks Dave and Don. What I did is I copied all information into persona.xls
as it has all the macros i have created and used it as the needed file. I
renamed a copy of it with the necessary name, send it to the recipient and it
worked.

Thanks again.

Reply to this Message