Since the OP said he'd "never used VB and don't know where to start",
the easiest route would be to use the existing button. But maybe I'm
missing something!

JLatham wrote:
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.


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