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 |
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 |
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 |
All times are GMT +1. The time now is 06:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com