In both Excel 2000 and Excel XP I have noticed this. I created a template, and in the template there is a macro (I also created) In order to use this macro, I press a custom menu button. The template saved as Template.xlt
When I want a new worksheet from this template (Template.xlt), the worksheet is called Template1.xls ...this is normal. When I run the macro, it works, when I look at where the the custom menu button, and where the macro is assigned, it points to Template1.xls...This is fine...
But, when I look at Template.xlt and look at where the custom button macro points to, it also points to Template1.xls. I want the template macro to point to the template, not the workbook spawned from the template.
I am sure this can't be how this works...
Am I suppose to use Add-ins?
Is the normal?
Any help would be appreciated.
thx,
Rodney Hess
rkhess@hot.rr.com
When I want a new worksheet from this template (Template.xlt), the worksheet is called Template1.xls ...this is normal. When I run the macro, it works, when I look at where the the custom menu button, and where the macro is assigned, it points to Template1.xls...This is fine...
But, when I look at Template.xlt and look at where the custom button macro points to, it also points to Template1.xls. I want the template macro to point to the template, not the workbook spawned from the template.
I am sure this can't be how this works...
Am I suppose to use Add-ins?
Is the normal?
Any help would be appreciated.
thx,
Rodney Hess
rkhess@hot.rr.com