Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distribute Personl.xls and excel.xlb for net use
I have created an excel makro which I saved in my
personl.xls. The makro was assigned to the menu. Now I want to share this makro with other users. So I copied the my personl.xls and excel.xlb and inserted the files in the respective folders of the another user. When this user starts Excel and wants to run the makro from the menu the user gets the error message that personl.xls is already open. However, the user can run the makro from the tools menu. How can I solve this problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distribute Personl.xls and excel.xlb for net use
The onaction property of the button is pointing to the wrong personal.xls.
Just edit the button to point to your current personal.xls. -- Regards, Tom Ogilvy "Petra Frimpong" wrote in message ... I have created an excel makro which I saved in my personl.xls. The makro was assigned to the menu. Now I want to share this makro with other users. So I copied the my personl.xls and excel.xlb and inserted the files in the respective folders of the another user. When this user starts Excel and wants to run the makro from the menu the user gets the error message that personl.xls is already open. However, the user can run the makro from the tools menu. How can I solve this problem? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distribute Personl.xls and excel.xlb for net use
It's a very, very bad idea to replace other people's excel.xlb files.
You just *destroyed all* their customization. Instead, change your code so that it behaves nicely. When it is loaded it creates the relevant menu/commandbar items (after checking for their existence) and removes them when it is unloaded. Also, consider distributing your code in the form of an add-in. For more, see http://groups.google.com/groups? selm=MPG.185a8ddd52ccd5ce98a88c%40msnews.microsoft .com -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have created an excel makro which I saved in my personl.xls. The makro was assigned to the menu. Now I want to share this makro with other users. So I copied the my personl.xls and excel.xlb and inserted the files in the respective folders of the another user. When this user starts Excel and wants to run the makro from the menu the user gets the error message that personl.xls is already open. However, the user can run the makro from the tools menu. How can I solve this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Distribute an add-in using a URL | Excel Discussion (Misc queries) | |||
new to 007: unhide personl.xlsb; | Charts and Charting in Excel | |||
How do I save an OLAP connection to distribute with an Excel sheet | Excel Discussion (Misc queries) | |||
How do I distribute copies of the excel viewer? | Excel Discussion (Misc queries) | |||
Can I Distribute Excel reports that retrieve Data-On-The-Fly ... | Excel Discussion (Misc queries) |