Printing the macro button

choungeehowe · Mar 7th, 2002, 07:34 AM

After putting in a button on my worksheet, I've assigned a macro on it. Now I'm trying to print the sheet wif the button but my print preview doesn't show the button. So I just printed it out to check whether the button would then be printed. But it still is not printed out. How come the buttons do not come out on the print preview when the buttons do exist in the worksheet. Can someone pls help me so that I am able to print out the buttons in my worksheet?

Steve Hartman · Mar 7th, 2002, 07:38 AM

Right click the button and choose format control. Check the print object box on the properties tab.

neo · Mar 7th, 2002, 07:39 AM

If you right-click the button on your sheet and select "format control", then choose the properties tab, you'll see a check box as the last choice "Printable object", or something close. if this is selected, your button should show up when you print the worksheet...

That it?

neo

Barrie Davidson · Mar 7th, 2002, 07:40 AM

Quote:

On 2002-03-07 06:34, choungeehowe wrote:
After putting in a button on my worksheet, I've assigned a macro on it. Now I'm trying to print the sheet wif the button but my print preview doesn't show the button. So I just printed it out to check whether the button would then be printed. But it still is not printed out. How come the buttons do not come out on the print preview when the buttons do exist in the worksheet. Can someone pls help me so that I am able to print out the buttons in my worksheet?

Right click on your button (I'm assuming it's a form button), select Format Control, select the Properties tab, and check off the Print Object check box.

Well it looks like I'm the bronze medalist on this question

Regards,

_________________

Barrie Davidson
My Excel Web Page

[ This Message was edited by: Barrie Davidson on 2002-03-07 06:41 ]

Steve Hartman · Mar 7th, 2002, 11:26 AM

Yeah but the French judge may have been on the take. You most likely deserved the gold!

Barrie Davidson · Mar 7th, 2002, 05:14 PM

Quote:

On 2002-03-07 10:26, Steve Hartman wrote:
Yeah but the French judge may have been on the take. You most likely deserved the gold! [img]/board/images/smiles/icon_lol.gif[/img]

You know, you may have something there!! I wonder who I need to bribe to ensure gold from now on.

PS - thanks for the laugh, it's been a rough couple of days and that's just what I needed.

Brian from Maui · Mar 7th, 2002, 05:21 PM

Barrie,

It's 80 degrees and sunny here!!!

Brian

Barrie Davidson · Mar 7th, 2002, 05:25 PM

Quote:

On 2002-03-07 16:21, Brian from Maui wrote:
Barrie,

It's 80 degrees and sunny here!!!

Brian

Ouch, you don't know how hard it is to read that when it's cold and white outside

Steve Hartman · Mar 8th, 2002, 10:59 PM

I went to college at Michigan State and my freshman year there was a guy on my dorm floor from Hawaii. We asked him WHY he left paradise to go to school in Michigan. He said he wanted to experience something different. One 12 degree F January morning with two feet of snow on the ground and more falling, I came across him standing on the sidewalk staring into the sky and mumbling over and over "What was I thinking?"

Mar 7th, 2002, 07:38 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Right click the button and choose format control. Check the print object box on the properties tab. __________________ Veni, Vidi, Velcro - I came, I saw, I stuck around Taxation WITH representation ain't so hot either

Mar 7th, 2002, 11:26 AM	#5
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Yeah but the French judge may have been on the take. You most likely deserved the gold! __________________ Veni, Vidi, Velcro - I came, I saw, I stuck around Taxation WITH representation ain't so hot either

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 07:34 AM	#1
choungeehowe New Member Join Date: Mar 2002 Posts: 13	After putting in a button on my worksheet, I've assigned a macro on it. Now I'm trying to print the sheet wif the button but my print preview doesn't show the button. So I just printed it out to check whether the button would then be printed. But it still is not printed out. How come the buttons do not come out on the print preview when the buttons do exist in the worksheet. Can someone pls help me so that I am able to print out the buttons in my worksheet?

Mar 7th, 2002, 07:39 AM	#3
neo New Member Join Date: Mar 2002 Location: Birmingham, Al Posts: 19	If you right-click the button on your sheet and select "format control", then choose the properties tab, you'll see a check box as the last choice "Printable object", or something close. if this is selected, your button should show up when you print the worksheet... That it? neo

Mar 7th, 2002, 05:21 PM	#7
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Barrie, It's 80 degrees and sunny here!!! Brian

Mar 8th, 2002, 10:59 PM	#9
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	I went to college at Michigan State and my freshman year there was a guy on my dorm floor from Hawaii. We asked him WHY he left paradise to go to school in Michigan. He said he wanted to experience something different. One 12 degree F January morning with two feet of snow on the ground and more falling, I came across him standing on the sidewalk staring into the sky and mumbling over and over "What was I thinking?"