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?


--
FCC
------------------------------------------------------------------------
FCC's Profile: http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=558277

Right click the button, Format ControlProperties, deselect Print Object.

NickHK

"FCC" wrote in message
...

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?


--
FCC
------------------------------------------------------------------------
FCC's Profile:
http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=558277

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

"FCC" wrote in message
...

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?


--
FCC
------------------------------------------------------------------------
FCC's Profile:
http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=558277

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

"Ken Johnson" wrote:

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

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

"Ray" wrote:

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

"Ken Johnson" wrote:

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

right click the button, choose 'Format Control' and the option is on the
'Properties' tab

"FCC" wrote in message
...

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?


--
FCC
------------------------------------------------------------------------
FCC's Profile:
http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=558277

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


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=558277

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=558277