|
Excel 03' -- Printing to exclude autoshapes?
I have a 1 page sheet that was created as a FORM, I've added 2 "autoshapes"
on the page that are assigned to macro used to send the sheet as an email upon click. How can I print this page but NOT have the shapes print out? I guess I can move the shapes off the page would be easiest....however users want to see the shapes/buttons on the page.. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Excel 03' -- Printing to exclude autoshapes?
Right click the Auto Shape. Select Format... On the Properties tab uncheck
Print Object. -- HTH... Jim Thomlinson "Lai704" wrote: I have a 1 page sheet that was created as a FORM, I've added 2 "autoshapes" on the page that are assigned to macro used to send the sheet as an email upon click. How can I print this page but NOT have the shapes print out? I guess I can move the shapes off the page would be easiest....however users want to see the shapes/buttons on the page.. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Excel 03' -- Printing to exclude autoshapes?
That did it. Thanks!
"Jim Thomlinson" wrote: Right click the Auto Shape. Select Format... On the Properties tab uncheck Print Object. -- HTH... Jim Thomlinson "Lai704" wrote: I have a 1 page sheet that was created as a FORM, I've added 2 "autoshapes" on the page that are assigned to macro used to send the sheet as an email upon click. How can I print this page but NOT have the shapes print out? I guess I can move the shapes off the page would be easiest....however users want to see the shapes/buttons on the page.. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Excel 03' -- Printing to exclude autoshapes?
MS won't even have to respond now to your suggestion<g
Gord Dibben MS Excel MVP On Tue, 19 Aug 2008 12:32:00 -0700, Lai704 wrote: That did it. Thanks! "Jim Thomlinson" wrote: Right click the Auto Shape. Select Format... On the Properties tab uncheck Print Object. -- HTH... Jim Thomlinson "Lai704" wrote: I have a 1 page sheet that was created as a FORM, I've added 2 "autoshapes" on the page that are assigned to macro used to send the sheet as an email upon click. How can I print this page but NOT have the shapes print out? I guess I can move the shapes off the page would be easiest....however users want to see the shapes/buttons on the page.. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
| All times are GMT +1. The time now is 03:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com