If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 news 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bug: Editing digitally signed templates with macros | EZStrobe | Visio | 0 | September 17th, 2005 06:19 PM |
Macros run inconsistently: run in old records or copies of old rec | HBrock | New Users | 1 | February 9th, 2005 11:48 AM |
Passing documents with macros and toolbar icons for the macros | SteveK | Powerpoint | 1 | February 7th, 2005 07:24 PM |
Macros in 2003 multiple but connected problems? | V-ger | General Discussion | 8 | January 18th, 2005 09:42 PM |
Using macros on custom toolbars in templates. | Conan Kelly | Worksheet Functions | 2 | August 2nd, 2004 02:28 PM |