Macros

  • Thread starter Thread starter alish
  • Start date Start date
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.
 
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.
 
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...
 
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.
 
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.
 
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.
 
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.
 
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.
 
Back
Top