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