Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pointing custom toolbar entries to correct macro path on copied workbooks
I have created an excel 2000 template (.xlt) containing a number o
macros. When I open copies of this template on various pcs, the macro function correctly, except I cannot successfully run the macros usin the custom toolbar I created, because (I think) within the toolbar th paths to the macros are pointed to the original location on my pc. An advice on how I can resolve this would be gratefully received -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pointing custom toolbar entries to correct macro path on copied workbooks
Save the workbook with you functions in it as an add-in (.xla) and the
use TollsAdd-ins to add the functions permanently. That should do the trick! :- -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pointing custom toolbar entries to correct macro path on copiedworkbooks
See replies at your other post.
"COR <" wrote: I have created an excel 2000 template (.xlt) containing a number of macros. When I open copies of this template on various pcs, the macros function correctly, except I cannot successfully run the macros using the custom toolbar I created, because (I think) within the toolbar the paths to the macros are pointed to the original location on my pc. Any advice on how I can resolve this would be gratefully received! --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to reassign a macro to a toolbar button because of path change | Excel Discussion (Misc queries) | |||
Custom Toolbar Macro - Path Name | Excel Discussion (Misc queries) | |||
XLapp.Workbooks.Open is not opening XL app but path is correct | Excel Discussion (Misc queries) | |||
Pointing to the Correct Directory | Excel Programming | |||
Custom Toolbar (Macro path changes) | Excel Programming |