Print Code

S

Scott

I have currently built a template where others can input invoicing data into
applicable cells and it gives them costing results out beside those cells. I
have made the template where they can enter 1,000 invoices if needed.

My question is...Is there a VBA code I can write or another way to create a
print option that will only print to the cells that have been populated and
not the entire 1,000 lines in the template?

Thanks
 
M

MartinW

Hi Scott,

Stop spoon feeding them! It's not very hard to select which
pages to print in the dialog box, and while they're at it they
can also check that they aren't printing in color etc.

Be strong!!! They're not children!!! (supposedly)

HTH
Martin
 
G

Gord Dibben

Scott

Probably would be better to create a real Template for your Invoices.

Then each copy would be one invoice only and users would fill in, print and
save.

You should have an Invoice Template in File>New...>on my computer.

Adjust that to your needs.


Gord Dibben MS Excel MVP
 
Top