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