| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i print all visible sheets ?
Title says it all !!!
Thanks for your help Luc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i print all visible sheets ?
Record a macro when you select/group all the sheets and print them. Remember to
ungroup them when you're done. Luc wrote: Title says it all !!! Thanks for your help Luc -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i print all visible sheets ?
Thanks, but the number of sheets is not fix, it can be 2 to x
"Dave Peterson" schreef in bericht ... Record a macro when you select/group all the sheets and print them. Remember to ungroup them when you're done. Luc wrote: Title says it all !!! Thanks for your help Luc -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i print all visible sheets ?
Try
http://www.rondebruin.nl/print.htm#Hidden -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Luc" wrote in message ... Thanks, but the number of sheets is not fix, it can be 2 to x "Dave Peterson" schreef in bericht ... Record a macro when you select/group all the sheets and print them. Remember to ungroup them when you're done. Luc wrote: Title says it all !!! Thanks for your help Luc -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i print all visible sheets ?
Hi
Try this one: Sub printSheets() For Each sh In ThisWorkbook.Sheets If sh.Visible = True Then sh.PrintOut End If Next End Sub Regards, Per "Luc" skrev i meddelelsen ... Thanks, but the number of sheets is not fix, it can be 2 to x "Dave Peterson" schreef in bericht ... Record a macro when you select/group all the sheets and print them. Remember to ungroup them when you're done. Luc wrote: Title says it all !!! Thanks for your help Luc -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i print all visible sheets ?
Rightclick on any of the sheet tabs that is visible.
You'll see an option to "select all sheets" This will select all 2 to x sheets. Luc wrote: Thanks, but the number of sheets is not fix, it can be 2 to x "Dave Peterson" schreef in bericht ... Record a macro when you select/group all the sheets and print them. Remember to ungroup them when you're done. Luc wrote: Title says it all !!! Thanks for your help Luc -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i print all visible sheets ?
Or you could just record a macro when you show the print dialog:
File|Print (in xl2003 menus) Select entireworkbook The hidden sheets won't be printed. Luc wrote: Thanks, but the number of sheets is not fix, it can be 2 to x "Dave Peterson" schreef in bericht ... Record a macro when you select/group all the sheets and print them. Remember to ungroup them when you're done. Luc wrote: Title says it all !!! Thanks for your help Luc -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Visible Sheets Macro | Excel Discussion (Misc queries) | |||
| Copy Two Visible Ranges (From Two Sheets) To A New Workbook (AlsoWith Two Sheets) | Excel Programming | |||
| Print visible sheets - ordering | Excel Programming | |||
| Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
| Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook | Excel Programming | |||
![Luc[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
