set the print area to one cell, eg A1, then protect the sheet. Of course,
you would need a macro to do not only this, but also to reset the print range
when you do want to print, and again set it to A1, after printing.
Alternatively, use a macro to set the visibility of the sheet to
XLVeryHidden, which means it is not visible, cannot be unhidden, except with
code, and can therefore not be printed.

--
HTH

Kassie

Replace xxx with hotmail


"sermest" wrote:

Hi,

I have a xls workbook in excel 2003 with multiple sheets with buttons,
protection, some sheets hided. I want users of this worksheet to be
able to print only certain sheets and restrict printing other sheets.
Is that possible?

Thanks,
sermest