Toolbar with Macros
 

I am using Excel 97.

I have an excel template which has a toolbar attached to
it. The code for each of the buttons on this toolbar is
stored within the template. When I run a new spreadsheet
from the template the code on the toolbars buttons follows
the new spreadsheet. Then when I open the template some
time later sometimes the code behind the buttons on the
toolbar have changed to the spreadsheet that I created
from the template! Is there a way of preventing this.

I know I could put the code in my personal workbook but
thi is not suitable as the template will potentially be
put on over 1000 computers and some users will have their
own personal workbook with other code in it.

Any solutions, please?


Mark

Toolbar with Macros
 

Mark,

Put the code in an addin, and distribute the addin to your users.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark" wrote in message
...
I am using Excel 97.

I have an excel template which has a toolbar attached to
it. The code for each of the buttons on this toolbar is
stored within the template. When I run a new spreadsheet
from the template the code on the toolbars buttons follows
the new spreadsheet. Then when I open the template some
time later sometimes the code behind the buttons on the
toolbar have changed to the spreadsheet that I created
from the template! Is there a way of preventing this.

I know I could put the code in my personal workbook but
thi is not suitable as the template will potentially be
put on over 1000 computers and some users will have their
own personal workbook with other code in it.

Any solutions, please?


Mark