Perhaps I read too much into the question? With the mention of VB I kind of
presumed that groaner was looking to put a button on the sheet, in kind of a
menu fashion, as opposed to using the built in one-click button on the
toolbar?

But glad you jumped in and looked it from that angle. Obviously a much
simpler solution.

"Debra Dalgleish" wrote:

If you're finding it difficult to follow any of the instructions that
you've found, you could just use the Print button on the Excel toolbar.


wrote:
I've looked all over the web. I've searched this group. Every answer I
find assumes that I already know how to do it. I've never used VB and
don't know where to start.

I just want to place a button on the screen that, when clicked, prints
the print area.

Forever Grateful
Johnnie



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html