VBA Code for Print exclude not working

**sintek** · 07-23-2016, 04:27 AM

Hi All

I have the following codes for a print exclude that does not work - it should but prints out all sheets. Any Ideas Please.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**xladept** · 07-23-2016, 11:36 AM

Maybe:

Please Login or Register  to view this content.

**sintek** · 07-23-2016, 11:56 AM

Hi xladept

Thanks for input....Unfortunately still prints all worksheets

**xladept** · 07-23-2016, 11:59 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**sintek** · 07-23-2016, 12:17 PM

Hi Xladept

Have generated 2 extra worksheets as Linka & Jenny...These are the to that I need to print via Userform "Print Payslips" button.

**sintek** · 07-23-2016, 12:35 PM

Hi xladept

I just noticed it is doing the same for populating of worksheets. It is also populating my exclusions Sheet 1-3.

**xladept** · 07-23-2016, 12:51 PM

Hi sintek,

It ran like a charm!

Please Login or Register  to view this content.

**sintek** · 07-23-2016, 12:59 PM

Hi xladept

On my side, all the sheets are printed....(printpreviewed) and all my sheets are also populated by another macro where they should not be.....Am I doing something wrong as a whole cause the :

Please Login or Register  to view this content.

is not working as a whole.

**xladept** · 07-23-2016, 01:13 PM

I see that the ws.name is case sensitive and in the sample you sent they are all upper case but your other program is proper case - try:

Please Login or Register  to view this content.

**sintek** · 07-23-2016, 01:18 PM

xladept....Works perfectly. Thanks

I don't understand though.

**xladept** · 07-23-2016, 01:25 PM

Hi sintek,

The sheet names have to match exactly: DATABASE will not Match Database etc.

So, by comparing a lower case sheet name with database we can get our match.

Hope that's enough to explain. If not I'll try too be more explicit

Orrin

**sintek** · 07-23-2016, 01:31 PM

Now I understand...Awesome thanks for all input.

**xladept** · 07-23-2016, 01:39 PM

Glad you got it! And, thanks for the rep!

VBA Code for Print exclude not working

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Re: VBA Code for Print exclude not working

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Print Macro with exclude range

[SOLVED] Private sub code no longer working (print area macro)

[SOLVED] seeking formula to exclude non working hours

Set Print Area Macro - Exclude Blank Rows

Code to print columns with active rows not working

Print to exclude fill colors on worksheets

Print Code not working

Bookmarks

Bookmarks

Posting Permissions