Check box selection for sheet printing

[SimonDann]

Hi

I'm looking to add a front sheet to my parts workbook that will allow checkbox selection of the sheets to be printed when command button is pressed. The workbook has approximately 190 sheets so ctrl select becomes a pain!

In my naivety I assumed that a command button that has the following would work:

Please Login or Register  to view this content.

Clearly not as it does nothing! I'm new to the programming as you may guess! Any help gratefully received.

[Kaper]

As you not declared b2, b4 or b6 these are treated as Variant variables (not addresses as you could suppose)

Try:

Please Login or Register  to view this content.

[Keebellah]

Hi, welcome to the forum.
Let me point out that it is important to include the version of Excel you're using.
I suggest you just list all the worksheets in several columns in such a way that it's readable.
You could add a right-click event to do what you want.
The idea:
Select the cell with the worksheet name, right click and then print it.
The macro would be to print the selected sheet name:

Sheets(< target.value>).Printout
You will have to take care of the page lay-out and so.

Please Login or Register  to view this content.

The above code should work if you have a worksheet with all the names

Just place this code in the sheet's VBA
enter a sheet name in any cell let's say B2
Then right-click B2 and it should work

[SimonDann]

Many thanks to you both. With your help I've got to the point where I've created a trial file with the cover sheet like this:
Trial1.jpg

The code is:

Please Login or Register  to view this content.

Works a treat.

[Keebellah]

Yes, looks good, but what are going to do about the other 186 sheets ?

[SimonDann]

Sheets are selected based on job requirements. The final version will have dropdown box selection as well as check box's. It will cover all of the workbook sheets but normally only about 15-20 are needed each time. The trail above was just to prove the coding.

[Keebellah]

And how do you plan to select these 15-20 sheets?

[SimonDann]

From a mixture of drop down box's and check box's, as I said above!