Macros on other computers....

**Sparkybear** · 08-24-2008, 07:48 AM

Hi all

(Excel 2003)

I am relatively new to Excel but am trying hard to learn, so if this is a daft question I apologise up front.

I run a bowling club and am using Excel to record league results, work out the league etc etc.

On the league worksheet, I have the league and have placed a button on the sheet which sorts the league into highest points, etc etc.

Everything works fine except for one thing..... Some of the leagues are controlled by other people. I do al the "techy" stuff for them and there job is solely to enter the results and then print out leagues on a week by week basis. THe problem is, I emailed the appropriate leagues to each person, they pen up the file and can enter the info without any problem. However when they press the button to sort the leagues it says it cant find the relavent macro. To sort the problem, I have to visit each of them and re-record the macro etc, then it works fine.

My question is this.... Is their a way to "package" the macro with the saved .xls file when I email them the file OR is their another way around this problem?

Thanks v much

**VBA Noob** · 08-24-2008, 08:29 AM

Maybe you are saving the macro as a personal macro instead of workbook macro (see link)

http://www.bettersolutions.com/excel...C420921011.htm

If you are using a button make sure you included the full name (workbook name and macro name)

e.g

'Book1.xls'!YourMacroName

or you could take a look at adding a custom menu

http://www.ozgrid.com/VBA/custom-menus.htm

VBA Noob

**Sparkybear** · 08-24-2008, 09:09 AM

Originally Posted by VBA Noob

Maybe you are saving the macro as a personal macro instead of workbook macro (see link)

If you are using a button make sure you included the full name (workbook name and macro name)

e.g

'Book1.xls'!YourMacroName

or you could take a look at adding a custom menu

http://www.ozgrid.com/VBA/custom-menus.htm

VBA Noob

Thanks VBA Noob

I did choose the save in "This Workbook" so I dont think thats the problem.

Excuse my ignorance but, when you say "If you are using a button make sure you included the full name (workbook name and macro name)"

I take it you mean in the assign macro property? Sorry for what is no doubt a dumb question.

I will try the other method later this afternoon.

Thanks in meantime,

**VBA Noob** · 08-24-2008, 09:16 AM

Excuse my ignorance but, when you say "If you are using a button make sure you included the full name (workbook name and macro name)"

You didn't say how the other person was calling the macro. One method is to add a button to call the macro. Other methods
http://www.bettersolutions.com/excel...C216621011.htm

VBA Noob

**Sparkybear** · 08-24-2008, 09:23 AM

Originally Posted by VBA Noob

You didn't say how the other person was calling the macro. One method is to add a button to call the macro. Other methods
http://www.bettersolutions.com/excel...C216621011.htm

VBA Noob

Sorry

I just realised what I "THINK" you meant after I posted my reply, you obviously had read it before I edited my reply, sorry....

As per my edit, I take it you meant to make sure 'Book1.xls'!YourMacroName was in the assign to proprty of the button.. Yes? If so it is and am still getting the problem. Maybe the other way is the only answer. Unless you can suggest anything else.

Thanks again