print question

bam12

Well-known Member
Joined
Dec 6, 2004
Messages
984
is there a way to print a workbook but not to print certain sheets within that worklbook without doing a macro?

If have to do a macro, could you direct me in where to look for an answer

Thanks
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Just select the tabs (sheets) you DO want to print and in your print window choose ACTIVE SHEETS.
 
Upvote 0
You can print just selected worksheets.
Ctrl-Click just the worksheet tabs you want to print. Then Click print and make sure under "Print What" it reads "Active Sheets".
 
Upvote 0
Thanks

Thanks i knew that, but person that wants this does not want to do tha evertime he want to print, i was wondering if a macro could be made up
 
Upvote 0
Yes, code could be used.
Will the same worksheets always be printed? If so, will there be a list of their names somewhere or would that need to be hard coded into the code? Maybe a list of the sheets NOT being printed would be shorter. If so, can you post them?
 
Upvote 0

Forum statistics

Threads
1,216,172
Messages
6,129,292
Members
449,498
Latest member
Lee_ray

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top