User talk:Krishnap2w2

Removed your edit on the discussion page
Hi, I had removed your edit on the discussion page containing this:-

How to Print only Selected Objects in Excel?
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.

1 Select the required check boxes 2 Press Alt+f11. A ‘Microsoft visual basic‘ window appears. 3 Double click on ‘This Workbook’. The cursor appears in the space at the right side, under the Workbook tab. 4 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 5 After writing the macro, go to the worksheet and print the page, Now you can see the print out with selected objects only.

Excel Consultants

This does not fit here. You can add this to any book instead and improve it. Have a question? You can discuss that on the discussion pages.--Leaderboard (discuss • contribs) 15:27, 1 March 2015 (UTC)