Exclude printing a specific worksheet in a workbook

**Steven811** · 08-28-2012, 09:53 AM

Hi

I use the following macro to print pages with data but, have added another worksheet that is filled with data that I do not wish to print. Can you help please with how I exclude a worksheet called Time Calc?

Please Login or Register  to view this content.

**HaHoBe** · 08-28-2012, 09:57 AM

Hi, Steven811,

please use Code-Tags to display your code.

Use the event in ThisWorkbook

Please Login or Register  to view this content.

Ciao,
Holger

**Steven811** · 08-28-2012, 10:06 AM

Thank you for the prompt reply. I'll give it a try.

I did use the tags and they show in the preview, hmm.

**HaHoBe** · 08-28-2012, 10:20 AM

Hi, Steven,

maybe another demand on the vBulletin team: this forum is "not in harmony with the rest of the world": slow in response (can´t be that many users in the database by the same time), not showing all features, sometimes even not willing to communicate with the users (like on Sunday) - a board of wonders

Thanks for adding the tags.

Ciao,
Holger

**Steven811** · 08-28-2012, 10:30 AM

Hi Holger

I've fixed the tags issue, my stupid mistake.

I haven't worked with this spreadsheet for a while and I've created a new module and inserted the code, then becuase that didn't work I've experimented with inserting it into the print routine and that didn't go so well either.

Could you advise me where to put this code please?

**HaHoBe** · 08-28-2012, 10:45 AM

Hi, Steven811,

my example is an event that is triggered whenever any kind of printing takes place (even a Preview). This event needs to be placed in ThisWorkbook, not a normal module, not behind a sheet.

You could amend it to first check for the sheet name to cancel and else call the macro:

Please Login or Register  to view this content.

This event will be called from all printing items in the workbook that Excel delivers.

HTH
Holger

**Steven811** · 08-28-2012, 11:09 AM

Hi Holger

I have noticed that there is now an issue with printing the worksheets. For some reason when I reordered the worksheets the sheets with data namely

"Info", "Logos 1" and Logos 2" do not print, only "Info"
Emily Roberts_3.2.xlsm
The pages that need to be excluded are "Time Calc", "Quotation", "Print PO"

I've added the spread sheet if that helps.

Any ideas would be gratefully received.

Thanks

Steven811

**HaHoBe** · 08-28-2012, 03:23 PM

Hi, Steven811,

Sheets("Time Calcs") will print as only Sheets("Time Calc") is checked (Typo).

The event in ThisWorkbook was missing. I added that but changed the code to

Please Login or Register  to view this content.

I checked the procedure with all cases of the first instance in PrintPreview - and they didn´t show up (what was expected, but Info was displayed when tested). Like explained earlier I just used Excel´s own commands for Print/PrintPreview.

I would like you to check as well. Please feel free to come back if anything is not working the way you expect it to be.

Ciao,
Holger

*****
Sorry but I missed the typo although I mentioned it in my post. Please correct the name to Time Calcs. Thank you

**Steven811** · 08-29-2012, 04:35 AM

Hi Holger

Thank you for your assistance.

The print macro was designed to print only those pages holding current job data and they are "Info" and Logos 1 through to Cap logo. Everything else is excluded. With the event code in ThisWorkbook I'm printing out only the info page and none of the logos pages.

I've now moved all of the Time Calcs data to "Machine logo costs" and deleted the work sheet "Time Calcs" the print macro works correctly.