View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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