sending macros

Hello,

When I save a macro in workbook and send it to others, they can not run it.
The macro is saved in personal.xls. THe marco simply does not exsist when I
send to others.

What am I doing wrong

You're probably not doing anything wrong - but they are not saving the
personal.xls file in the proper location on their computer. Tell them to
save it in their XLSTART folder (do a search on the system to find it) it is
usually in a place like:
C:\Documents and Settings\username\Application Data\Microsoft\Excel
where username is their login name.

They could also set things up to always open up files in any specific folder
by using Tools| Options and entering a path to a folder in the "At startup,
open all files in:" entry space on the [General Tab].

Personal.xls is a good way to always have macros available if that's what
you want. If you want macros associated with just one workbook, save them in
that workbook. You can export just the code into a .bas file from within the
Excel VB Editor. To get into the editor, simply hit [Alt]+[F11].

"Dawn" wrote:

> Hello,
>
> When I save a macro in workbook and send it to others, they can not run it.
> The macro is saved in personal.xls. THe marco simply does not exsist when I
> send to others.
>
> What am I doing wrong

Unless you sent your personal.xls and told the user to replace theirs with
yours, you might want to copy the macro and give instructions to the end
user as to where to put it. Some people are fussy about their personal.xls
file.

You should put the macro in the workbook you send.


--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Dawn" <Dawn @discussions.microsoft.com> wrote in message
news:DE03317D-2768-4508-9B75-EB4E69647AAC@microsoft.com...
> Hello,
>
> When I save a macro in workbook and send it to others, they can not run
> it.
> The macro is saved in personal.xls. THe marco simply does not exsist when
> I
> send to others.
>
> What am I doing wrong