Thread: sending macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default sending macros

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