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

[Kate]

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

 

[Gordon]

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)

 

[Gord Dibben]

Single-click?

No.

Not without some VBA.


Gord Dibben Excel MVP

 

[Kate]

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.

 

[Anne Troy]

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/record_a_macro_in_microsoft_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