![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Apr 2002
Location: Ireland
Posts: 107
|
Just a quick question bout printing forms. I have the actually function of printing the form working grand but how do u make it so it prints the text only and not the print button and the form background etc? And also to center it in the page if possible rather than in top left corner? Thanks for your help,
__________________
[Brian] |
|
|
|
|
|
#2 |
|
New Member
Join Date: May 2002
Posts: 4
|
in the printer set up options ther is an option of center horizontally/vertically, and also print grid lines.
play about with the tick boxes hope this helps |
|
|
|
|
|
#3 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Helena, MT
Posts: 13,690
|
You can control the printing of a button from the Format Control dialog. Right click on the Control, Choose Format Control>Properties. Deselect the Print Object Box
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|