Macros

A

alish

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.
 
D

Dave Peterson

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.
 
A

alish

Dave Peterson said:
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.
Click to expand...
 
A

alish

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.
 
A

alish

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.
 
D

Don Guillett

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.
 
D

Dave Peterson

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.
 
A

alish

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.
 
Top