printing pre-printed forms
 

Is the any way to use excel to print pre-printed
forms ( invoices , etc ) after all datas are entered?
Is there any way to design a template for that ?
Tks !!
Osvaldo

printing pre-printed forms
 

If the form is on an excel worksheet - than it can be printed.

You can get basic code by performing the print with the macro recorder
turned on.
Than modify your code. You can include page setup if you desire (but VBE
page setup is slow).

You can put the code in the workbook and use a sheet button to activate it;
or you can put it into Your Personal.xls and create a toolbar button to
activate it.

--
steveB

Remove "AYN" from email to respond
"Osvaldo" wrote in message
oups.com...
Is the any way to use excel to print pre-printed
forms ( invoices , etc ) after all datas are entered?
Is there any way to design a template for that ?
Tks !!
Osvaldo