Command Buttons and not Printing Them

[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?

[mudraker]

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

[Leith Ross]

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

[NickHK]

Right click the button, Format Control>Properties, deselect Print Object.

NickHK

"FCC" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Tim Marsh]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Tim Marsh]

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

"FCC" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Ken Johnson]

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

[Ray]

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
>
>

[lumch]

I am blind I cant find it. here is a pic of my properties box for an image.properties.PNG

[Logit]

Tim Marsh

Good job ! Keep it up.