Discussion Locked

print button help

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
i have a workbook with several sheets. one of the sheets is my data base sheet. it has over 500 products listed in it...i want to be able to print only the ones out of this 500 that actually have a number in the column..this coulmn would be g1:g500.i also only want to print column a,b,and g. i want it to go to my default printer..and i want to have a button that says print on it on my sheet 2 at b9...can you show me how this be done automation style?

3 replies

by dklippert

1) Select the area then go to File Set Print area. Now when you click on the default print icon it will print just that range

or

Go to Tools>Macro Record Macro.
Go through the motions of setting up the job. Select the area and choose print selection. Now add a button to the sheet using the Form toolbar and assign the macro.

or
Look up Custom Views on the View menu. Define the view and you can assign it to a Report using Report Manager.

This discussion is closed to new replies.