Exclude worksheets from workbook print

  • Thread starter cabana_boy via OfficeKB.com
  • Start date
C

cabana_boy via OfficeKB.com

Hoping someone can help me with this. I have a rather large workbook (23
worksheets) that I'm using as a sort of database (because my employer thinks
Access is of the devil for some reason). I need to exclude the following
sheets from printing when I do a workbook print:

Foreign WD
On Us-Denials-Inquiries
Total Transactions
Availability
Surcharge
Interchange
Expenses
Profitability

Is there a way to do this?
 
B

Bob I

Select the desired worksheets, and then use "Active Sheets" instead of
"Workbook".
 
C

cabana_boy via OfficeKB.com

This workbook is going to be sent out to market presidents and I doubt
they'll want (or even understand) how to do that. Is there some setting I can
use in Excel that will automatically do this?

Bob said:
Select the desired worksheets, and then use "Active Sheets" instead of
"Workbook".
Hoping someone can help me with this. I have a rather large workbook (23
worksheets) that I'm using as a sort of database (because my employer thinks
[quoted text clipped - 11 lines]
Is there a way to do this?
 
B

Bob I

Possibly through the use of disabling them them from printing with VBA.
But macros will need to run. Someone else more versed in VBA may help
you there.

cabana_boy via OfficeKB.com said:
This workbook is going to be sent out to market presidents and I doubt
they'll want (or even understand) how to do that. Is there some setting I can
use in Excel that will automatically do this?

Bob said:
Select the desired worksheets, and then use "Active Sheets" instead of
"Workbook".

Hoping someone can help me with this. I have a rather large workbook (23
worksheets) that I'm using as a sort of database (because my employer thinks

[quoted text clipped - 11 lines]
Is there a way to do this?
 
C

cabana_boy via OfficeKB.com

Oh fun. Guess I'll post in the programming forum then...

Bob said:
Possibly through the use of disabling them them from printing with VBA.
But macros will need to run. Someone else more versed in VBA may help
you there.
This workbook is going to be sent out to market presidents and I doubt
they'll want (or even understand) how to do that. Is there some setting I can
[quoted text clipped - 9 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top