I discovered that after I posted. And yes, I can set that manually from the
worksheet using the Format Autoshape & Properties tab.

That is neat beacuse it always shows the shapes but never prints them.

Thanks for the help.

"Geof Wyght" wrote in message
...
Won't the PrintObject property of the button do? Set it to
False. An educated guess.
Geof.
-----Original Message-----
So I now have shapes that acts as buttons on my worksheet
thanks to help I
got from this group.

Now I want to hide those shapes before I print out the
report. So I plan to
add a macro, called from yet another button, to do a
print preview.

I'd like to hide those buttons before I do the print
preview and then unhide
them at the end of that macro.

From what I am begining to understand about the Exel
object model, I suspect
there is a collection of shapes on the workseeht and that
each shape in that
collection has a 'visible' property. Since all od the
shaps on this
worksheet are button, I will want to hide all of them.
And, I may even get
button happy and add more shapes.

So my question is:

How do I hide/unhide all the shapes on a worksheet?

Thanks,
Ken Loomis


.