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


.