JLatham wrote:
First record a macro to print the worksheet (go ahead and waste a sheet or
two of paper) you wish to print. Remember the name you gave it, even if it's
simply Macro1. Be sure you've defined the print area before creating the
macro.

Two ways to get a button onto the worksheet to do what you need:
#1 - use View | Toolbars | Forms to open up the forms toolbar. Select the
Button tool and use then click on the worksheet where you'd like it and drag
a rectangle to about the size you want it to be. Release it. A Window will
open asking which Macro to assign to it. Click the macro you created. Edit
the text on the button to read as you want it to. You can right-click on it
and change shape and drag it around on the worksheet. Right-click and choose
Properties to see other options for it such as remaining in place when cells
are moved/resized, stuff like that.

You can do similar thing with a Drawing object:
View | Toolbars | Drawing
The Textbox is easiest to work with - click on it, draw it on the sheet,
type in the prompting text for it. Right click on it and choose Assign Macro
and again choose the name of the previously recorded macro.

Good luck, hope this is what you needed.


" 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


Thanks. That started me out enough so that I could figure the simplest
way. I just went View..... Toolbars.... opened the Control Toolbox....
clicked the button icon.... drew a square.... right clicked it ......
chose CommandButton and named it "Print".... right clicked it again and
stuck Range (--:--).PrintOut between the subs..... then.... went and
had a martini.

Thanks again
Johnnie

P.S. The reason I wanted a print button is because.... and no, this is
not a joke..... some of the people who work for us don't know what all
those little pictures at the top of the screen mean.....hehe!