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

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

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

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

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

Like yourself, I'm just kind of trying to make a best guess as to what the OP
actually desires. Eye of the beholder kind of thing, I suppose. By
mentioning VB at all, it triggered a "wants to know how to do it with VB"
response in my head, along with the comment that he/she made the comment
about putting on the sheet itself. But I could certainly be wrong - would
not be a first for me here in these forums (or any of several others), all
any of us can do is make a best effort.

Although I completely agree that if they are new to Excel they may have not
even seen the [Print] button on the toolbar yet.

Unless the OP replies here and clues us in, then we may never know. In
either case, with your input and mine, they have an alternative ... which is
a good thing.

BTW: Great website, I've visited it more than once.

"Debra Dalgleish" wrote:

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

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!

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
chose View Code ......stuck Range (--:--).PrintOut between the
subs..... closed that window .... saved it..... 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!

Thanks! And now we know why the OP wanted a print button on the worksheet.

JLatham wrote:
Like yourself, I'm just kind of trying to make a best guess as to what the OP
actually desires. Eye of the beholder kind of thing, I suppose. By
mentioning VB at all, it triggered a "wants to know how to do it with VB"
response in my head, along with the comment that he/she made the comment
about putting on the sheet itself. But I could certainly be wrong - would
not be a first for me here in these forums (or any of several others), all
any of us can do is make a best effort.

Although I completely agree that if they are new to Excel they may have not
even seen the [Print] button on the toolbar yet.

Unless the OP replies here and clues us in, then we may never know. In
either case, with your input and mine, they have an alternative ... which is
a good thing.

BTW: Great website, I've visited it more than once.

"Debra Dalgleish" wrote:


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





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

You may want to make sure that the users have:
tools|Customize|Options tab
"Show ScreenTips on toolbars" checked

Then they can just let the cursor linger over the icons to see that little
yellow tooltip show up.



wrote:
<<snipped

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!

--

Dave Peterson