Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro

It shouldn't be difficult, what code do you have for printing?

By the way, what are you using the variable Print for?

Oh right, I thought you had an inividual print sub for each checkbox that would print a specific page, area, whatever.

What exactly do you need for the sub Print_Current_Workbook?

Set the print area, which pages to print?

im not exactly sure if the coding is possible, but what about this

at each check box, have the sheet name variable
and the coding inserts this variable into the module 2 print code.

i think that this would work if inserted into the module 2 print code
Sheets("Name").PrintOut
to print certain sheets.

is this possible? this way it keeps the coding shorter. also is there a time issue when multiple print code are set to the printer that you know of?
by timing issue i mean is the code going too fast for the transfer of information to the print spooler.

the coding just needs to print whole sheet, areas are not needed to for coding.

Don't know about writing the name of a sheet to the code, that is possible but not necessary I think, but what you could do is
pass a reference to or the name of the worksheet to be printed to the sub that does the printing?

What exactly is being printed with the sub at it is?

It looks like it's the entire workbook.

yes its the entire active workbook, how do i change this code to use " Sheets("Name").PrintOut " instead?

what im thinking for passing the variable sheet name is,

Please Login or Register  to view this content.

this of course not be a working code but a good understanding of what i need.
the print = 1 would be made when a button would be pressed to only print the sheets of the workbook.

All you should need in the print sub is this.

Please Login or Register  to view this content.

That is all you are doing isn't it, printing put one copy of the worksheet that's passed to the sub.

I posted the code you need to print one worksheet.

Please Login or Register  to view this content.

By the way, I thought you were going to use a seperate button for printing.

That code will print the worksheet that the variable ws refers to.

I actually thought the printing would be separate from what you have already.

The way I would do this would be to use a listbox to list all the worksheets.

It could be set up so there's a checkbox next to each worksheet name.

Then there would be a print button which would have code behind it that would only print worksheets that are checked in the listbox.

That might sound complicated and/or a lot of work but it really isn't.

i want to make this as automated as possible so as the person im training to fill my position can focus more on other things instead of data entry. i would like to do it this way if you could help...

this is what i have put together so far.

Please Login or Register  to view this content.

Wouldn't a listbox with a list of the sheets that can be printed be a good way to automate this for a user?

All they would need to do is select, from the listbox, the sheets they want to print and then click a button.

Any chance you could attach a workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

You could actually replace the existing checkboxes with a listbox.

That would make things a lot easier as you would only have one control to deal with.

The code would also be a lot shorter and more manageable.

What example is that?

If you were to attach an sample workbook I could demonstrate how a multiselect listbox might work.

There's no addin, and I really don't want to reconstruct the files/modules etc.

Sorry, you've lost me - you haven't upload anything?

What about the zip file which contains these files?

DEVICE PANEL ORDER.xlsx
Label_Generator ARROWHEAD.xlsm
Module1.bas
Module2.bas
Module3.bas
Module4.bas
Module5.bas
UserForm1.frm
UserForm1.frx

I tried reconstructing the xlsm file but kept on hitting errors, especially after I imported the 5 modules listed above.

By the way, code like this can be reduced by a fair bit if you get rid of all the selecting/activating.

Please Login or Register  to view this content.

Without activating/selecting.

Please Login or Register  to view this content.

There also appears to be a pattern in that code which could be used to make the code even shorter.

uploaded until now i mean... not sure about the errors, the modules are to be uploaded to the userform addin. im not sure how i can have it all packaged for you... other then the way you have it. the shortening of the code, ya i can shorten it but i have had errors where the code wont start in the correct spot. it would happen every once in a while. not sure if it was a compile error or not. better safe then sorry i think.

yes that workbook. code for going back and forth to another workbook.
also the modules that are in the file to be imported, has everything that you would need to run the userform. only thing is the generating code on each sheet of the generator. the modules in the generator are for backup in case something happened while i was coding. i have to use this while im programming.

Can't you just attach the files?

Like I said I tried to reconstruct the xlsm but when I imported Modules 1-5 I started to get a whole bunch of duplicate declaration compile errors.

That was caused by the subs in those modules already existing in one of the 9 modules in the workbook.

I'm not sure what you are saying about shortening the code.

As well as getting rid of the activating/selecting I added workbook references to ensure the right data was being copied to the right place, I would say that's safer than flipping between workbooks/worksheets/ranges.

the error isnt coming from the workbook... let me see what i can come up with

are you importing the modules into the userform module folder? remember that this userform is an addin.

Untitled.png