» Preventing the Printing of Objects
CATEGORY - Excel Printing
VERSION - All Microsoft Excel Versions
To prevent objects from being printed: Technique 1:
1. From the File menu, select Page Setup.
2. Select the Sheet tab.
3. In Print, select the Draft quality checkbox, and then click OK.
Technique 2:
1. Right-click the object (Button, Combo Box and more), and select Format Control.
2. Select the Properties tab.
3. Deselect the Print object checkbox, and then click OK.
Technique 3:
Objects make printing slower, so you may want to temporarily hide them before printing.
1. Press Ctrl+6+6 to hide objects in the sheets.
2. After printing, press Ctrl+6 to unhide the objects in the sheet.

Book Store:
Recommended Books:
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Writing Excel Macros with VBA, 2nd Edition
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Special Edition Using Microsoft Word 2002
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
No comments have been submitted.

