How do i print all visible sheets ?
 

Title says it all !!!

Thanks for your help

Luc

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

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

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

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

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

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