View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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