Command Buttons and not Printing Them

  • Thread starter Thread starter FCC
  • Start date Start date
F

FCC

Hello,

I have on one of my spreadsheets a command button which the users can
press to bring up a userform to enter information. Once the user does
all this stuff, they can press print to print the spreadsheet. The
problem with this is it also prints the command button.

Is there anyway I make it so that the printer doesn't print out the
command button too?
 
For Control toolbox buttons

Right click on button
Select properties
Change PrintObject setting to False


For Forms buttons
Right click on button
Select Format Control
Select properties
Remove Tick from Print Object
 
A question I can answer - wow!

if you right click on the button (in edit mode) and choose properties in the
short-cut menu, you'll see a property called 'Print Object'... set it to
false.

hth,

Tim
 
Hello FCC,

If your command button is a Control Toolbox type, you need to activate
design mode. Right click the control and select Format Control... from
the popup menu. Click the Properties tab and click the Print Object
Checkbox to clear it if it is set.

Sincerely,
Leith Ross
 
right click the button, choose 'Format Control' and the option is on the
'Properties' tab
 
Hi FCC,

Go View|Toolbars...check "Control Toolbox"
On the Control Toolbox make sure the "Design Mode" button is on.
Right click the Command Button|select Format Control| click the
Properties tab|deselect "Print object"|OK|Turn off Design Mode on the
Control Toolbox.

Ken Johnson
 
Is there anyway to do this for all buttons in a workbook, without having to
go into EVERY Properties box? A macro or something....?

thanks, ray
 
In case you are still looking for this: you can hold the Ctrl key down and
click each object to select all the ones to change; then set PrintObject to
False or deselect the Print object check box whichever is appropriate.
Jack
 
Back
Top