Macro Tuesdays – Print All Sheets In An Excel Workbook – With precise Exceptions

It’s that time of week for some Macro enjoyable, i really like starting off the week with some code!. In Macro Tuesday we looked at printing distinct worksheets in an Excel workbook, which in itself is really helpful, however what if you have a big variety of worksheets that you simply want printed except for only one?.

I suppose it makes extra feel (and more effective) to print the entire worksheets within the workbook and just omit the one sheet you dont desire in this state of affairs. So let’s get all started with writing a macro to just do that.

What Does The Macro Do?

This Macro will print every worksheet to your Excel workbook, except any worksheets you specify and name yourself in the macro code.

How Does It Work?

here's profit like ultimate weeks Macro Mondays illustration is pretty standard, we use the PrintOut system to print all worksheets within the workbook however specify an exception the use of the does not equal to ‘<> ‘ piece of code. Lets get caught into this macro!

FIRST Create A Module. Open visible simple – by way of hitting F11 or Developer Tab – visual basic

Step 1 . Declare our variables. we're declaring that there is an object referred to as ws, which creates a reminiscence container for each and every of the worksheets we loop through.

Step 2. We get Excel to begin looping though all the worksheets within the actve workbook, to see if the a sheet name is not equal to MyTestSheet

Step 3. If the worksheet identify is not equal to MyTestSheet then the worksheet is printed

Step four. here is the closing commentary of the loop.

Step 5. verify your Macro – the fun bit!