Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sending macros
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 "Dawn" <Dawn @discussions.microsoft.com wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Have problem sending spreadsheet email and losing custom toolbar and macros | Excel Discussion (Misc queries) | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |