How do I print all worksheets in Excel with one click?

Hello,

Without using any scripting, is there a way to print all worksheets in Excel
with a single click?

I am using Excel 2000.

Thanks

"Kate" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> Without using any scripting, is there a way to print all worksheets in
Excel
> with a single click?
>
> I am using Excel 2000.
>
> Thanks

Highlight all sheets, (Click on first sheet, then Ctl-click on last) and
click print. (That's three clicks but it's the nearest you'll get without
writing a macro)

Single-click?

No.

Not without some VBA.


Gord Dibben Excel MVP

On Fri, 29 Jul 2005 01:08:01 -0700, "Kate" <[email protected]>
wrote:

>Hello,
>
>Without using any scripting, is there a way to print all worksheets in Excel
>with a single click?
>
>I am using Excel 2000.
>
>Thanks

Thanks for your replies.

Can you show me a good tutorial site or point me on how to get started on
learning this?

Thanks again.


"Gord Dibben" wrote:

> Single-click?
>
> No.
>
> Not without some VBA.
>
>
> Gord Dibben Excel MVP
>
> On Fri, 29 Jul 2005 01:08:01 -0700, "Kate" <[email protected]>
> wrote:
>
> >Hello,
> >
> >Without using any scripting, is there a way to print all worksheets in Excel
> >with a single click?
> >
> >I am using Excel 2000.
> >
> >Thanks
>
>

Kate, you can take the steps Gordon (Not Gord) gave, and record a macro.
It's one of the quickest ways to begin learning them anyway. Here's a
walk-through:
http://www.officearticles.com/excel/...soft_excel.htm

And Lesson 1 of VBA training, which is a very good intro and is free, is
here:
http://www.vbaexpress.com/training/lesson01.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Kate" <[email protected]> wrote in message
news:[email protected]...
> Thanks for your replies.
>
> Can you show me a good tutorial site or point me on how to get started on
> learning this?
>
> Thanks again.
>
>
> "Gord Dibben" wrote:
>
> > Single-click?
> >
> > No.
> >
> > Not without some VBA.
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Fri, 29 Jul 2005 01:08:01 -0700, "Kate"
<[email protected]>
> > wrote:
> >
> > >Hello,
> > >
> > >Without using any scripting, is there a way to print all worksheets in
Excel
> > >with a single click?
> > >
> > >I am using Excel 2000.
> > >
> > >Thanks
> >
> >