| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.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 |
|
#3
Posted to microsoft.public.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 |
|
#4
Posted to microsoft.public.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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Selected worksheets but exclude the sheet "Sheets" | Excel Discussion (Misc queries) | |||
| Exclude Individual Cells While Printing | Excel Discussion (Misc queries) | |||
| Exclude certain cells from printing. | Excel Worksheet Functions | |||
| Is there a way to exclude hidden rows/columns when printing a doc | Setting up and Configuration of Excel | |||
| How to exclude single cell from printing | Excel Discussion (Misc queries) | |||
Linear Mode
