Problem to recognize macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top