Discussion Locked
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.
by hotrodgers
Poster rated this answer
by hotrodgers
This question was closed by the author
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
0 helpful
1 reply
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
Question Unanswered
How do you protect downloadable files on a WordPress store?
0 helpful
0 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply