I am using a macro to direct the out print to two different printers and that
is ok,
But I am using a button in the sheet for it and when I am saving it as a
template and then are trying to use it I get the message cant find macro
€œsheet1!macro1€� for example. The problem appers when I am saving it as a
template.

Instead of using a button from the Forms toolbar, use a commandbutton from the
Control Toolbox Toolbar.

And move your code to that button's _click event.

You may have to modify the code a bit, too.

Stefan wrote:

I am using a macro to direct the out print to two different printers and that
is ok,
But I am using a button in the sheet for it and when I am saving it as a
template and then are trying to use it I get the message cant find macro
€œsheet1!macro1€� for example. The problem appers when I am saving it as a
template.

--

Dave Peterson

Thanks Dave Peterson

It helpt me and everything is working good.

I am sorry that my question is on two places but I had forgotten to write my
e-mail address so I thought it was not published
/Stefan

"Dave Peterson" wrote:

Instead of using a button from the Forms toolbar, use a commandbutton from the
Control Toolbox Toolbar.

And move your code to that button's _click event.

You may have to modify the code a bit, too.

Stefan wrote:

I am using a macro to direct the out print to two different printers and that
is ok,
But I am using a button in the sheet for it and when I am saving it as a
template and then are trying to use it I get the message cant find macro
€œsheet1!macro1€� for example. The problem appers when I am saving it as a
template.

--

Dave Peterson