How do you create a macro to print out all worksheets except for two specific worksheets

[mac_us_27]

I am trying to create a macro that will print out all worksheets except for two worksheets I do not want printed out. The worksheets already have defined printing areas so I do not need to set which cell range to print.

I am looking for help with the code to print all sheets except for ABC and DEF worksheets.

Thank you

[ratcat]

G'day and welcome,

I've used this method on one of my workbook. Method supplied by Ron de Bruin. Information is found on This page and scroll down to the title Print every Worksheet with a value In cell A1.

Please Login or Register  to view this content.

[mac_us_27]

Not sure I am following you. I want to be able to exclude certain worksheets within the file. Where is the area I can exclude the specific worksheets. For example, where can I place the names of the worksheets I do not want printed?

[ratcat]

Find a same cell in each spreadsheet that empty on the spreadsheet you like to print, place the text 'Printme' (without quotes) in that cell.

Then change this line in the vba

If Sh.Visible = xlSheetVisible And Sh.Range("A1").Value <> "Printme" Then

Then run the macro.

Note: I'm still a vba novice

[mac_us_27]

Isn't there a way I can have excel exclude certain prenamed worksheets I have that I do not want printed and then print everything else?

[jolivanes]

Can you change the attached to your wishes?
If not, just ask.

[mac_us_27]

This still seems too complicated. Is there a way I can do this in one button. I only want the macro to print out all worksheets except for three sheets called "ABC", "DEF", and "XYZ". What would be great is a macro that prints out all of the worksheets that are not any of the three. Is this possible?

[ratcat]

Okay I've got a workbook working but to the opposite what I've stated above.

The workbook I have working is at work so I can't review on what I've done properly too it work.

See the attachment for details. bbl need to do a shop run.

[jolivanes]

Like this you mean?

Please Login or Register  to view this content.

Or have a read about Select Case