I have started programming Excel for our business, tracking customer, pricing
job and accounts , How can I get Excel to print the invoices or statements
automatically ?without going to every open account and telling it to print.
Or is there away to set up the account so it will be automatic? Hope
someone can help this blond:) Thank you Toni

Toni
You have to tell us a bit more about the layout of what you have. Are
the invoices or statements in different sheets in one workbook (file)? You
say "every open account". Do you have a different workbook for each
account?
You say "Or is there away to set up the account so it will be automatic?"
You can setup for automatic execution of macros in many ways. Again, we
have to know what you have. For instance, what would you choose to happen
to trigger the macro execution? Post back with more information. HTH
Otto
"programming automatc printing" <programming automatc
wrote in message
...
I have started programming Excel for our business, tracking customer,
pricing
job and accounts , How can I get Excel to print the invoices or statements
automatically ?without going to every open account and telling it to
print.
Or is there away to set up the account so it will be automatic? Hope
someone can help this blond:) Thank you Toni