Excel 03' -- Printing to exclude autoshapes?

[Lai704]

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/com...b-3422879fdf69&dg=microsoft.public.excel.misc

 

[Jim Thomlinson]

Right click the Auto Shape. Select Format... On the Properties tab uncheck
Print Object.

 

[Lai704]

That did it. Thanks!

Right click the Auto Shape. Select Format... On the Properties tab uncheck
Print Object.

 

[Gord Dibben]

MS won't even have to respond now to your suggestion<g>


Gord Dibben MS Excel MVP