Problem to recognize macro

[Stefan]

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]

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]

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