Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
"Kate" wrote in message
... 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) |
#3
|
|||
|
|||
Single-click?
No. Not without some VBA. Gord Dibben Excel MVP On Fri, 29 Jul 2005 01:08:01 -0700, "Kate" 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 |
#4
|
|||
|
|||
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" 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 |
#5
|
|||
|
|||
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 he http://www.vbaexpress.com/training/lesson01.htm ******************* ~Anne Troy www.OfficeArticles.com "Kate" wrote in message ... 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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
how can I enter books of the bible into excel and print out bingo. | New Users to Excel | |||
Excel 2002 Will Not Print Text Boxes | Excel Discussion (Misc queries) | |||
How can I print a specified page from several worksheets in Exce. | Excel Worksheet Functions | |||
How can I print an excel chart so a picture is not distorted? | Charts and Charting in Excel |