How to Print Only Selected Objects in Excel?

Printing in Excel is a bit different than printing in some other programs, such as a word processor. Printing selected objects is one of the special features in Excel.

Worksheet with Objects.


Print out with selected objects.

The steps below guide us to print only selected objects , from a number of objects (i.e. controls, images, shapes etc) in a worksheet.

Select the required check boxes.


Press Alt+f11.

A ‘Microsoft visual basic‘ window appears.

Double click on ‘This Workbook’. The cursor appears in the space at the right
viagra for sale

side, under the Workbook tab.

Now type the code below:

Private Sub Workbook_BeforePrint (Cancel As Boolean)

Dim CBX As CheckBox

For Each CBX In ActiveSheet.CheckBoxes

If CBX.Value = xlOff Then CBX.PrintObject = False

Next CBX

End Sub

After writing the macro, go to the worksheet and print the page, Now you can see the print out with selected objects only.

 

————————————————————————————————————–

Vani is a Business

cialis

Associate with p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel ModelingExcel DashboardsProfitability Analysis,  Excel Invoicesand Excel Bid sheets. You can contact us by email: cs [at] p2w2.com or call us at 305.600.0950.


[Bloglines] [del.icio.us] [Digg] [diigo] [Facebook] [Furl] [Google] [kirtsy] [Ma.gnolia] [MySpace] [Propeller] [Reddit] [Simpy] [Sphinn] [StumbleUpon] [Technorati] [Windows Live] [Yahoo!]


6 Comments

  • By hamilton beach big mouth juicer, January 16, 2015 @ 1:24 am

    The types that are available are numerous and you can choose your pick from the ones that range from hand press models to ones that
    are electrically operated. There are many different ways
    to enjoy the wonder of a Disney holiday. Should you favor a relaxing time, then the spectacular seashores Dubai has to offer could be the ultimate location for relaxation.

  • By Replacement Windows, January 16, 2015 @ 9:07 pm

    To install the Windows 7 Bluetooth stack you
    need to first connect a Bluetooth device via USB; this will begin the Windows Add new hardware wizard and once complete your
    device will have control over the Bluetooth connection protocols included in the Windows 7 stack.
    But keep in mind that wood can also shrink, rot, and warp, which means you’ll probably have to replace your windows
    over and over. Vinyl windows made of vinyl or PVC (polyvinyl Chloride) offers great durability than other traditional window materials such
    as wood or aluminum.

  • By weight loss success stories before and after, February 10, 2015 @ 5:13 am

    No question about it, you know you want to lose the weight.
    The excess glucose when not handled because there’s not enough insulin ends up
    as fat storage and hence weight gain. This helps to improve
    digestion and allows your brain to receive the “I’m full” signal quicker before you stuff in too much food.

  • By kids clothes stores online canada rx, February 14, 2015 @ 9:36 pm

    Moreover, ninja history should be read quickly in order to know about the
    real ninja gear for kids. Also, consider the types of goggle straps available with the piece.
    Who cann forget the chant ‘Trick or Treat’ that kids chant through the season.

  • By Sheree, March 29, 2015 @ 8:42 am

    There you have it, a sure-fire vegetarian weight loss diet plan that ANY vegetarian can succeed,
    only when you put it into full action. Journal of Consujlting and Clinical Psychology, 1986:
    Vol. Over time however dieters will want to get rid of sugary
    sodas totally out of their everyday activities.

  • By dilioptim, April 16, 2015 @ 12:22 am

    I’ve read a few excellent stuff here. Definitely worth bookmarking for revisiting. I wonder how much attempt you put to make such a great informative site.

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment