How to restrict printing certain sheets

  • Thread starter Thread starter sermest
  • Start date Start date
S

sermest

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
 
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
 
Kassie said:
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.
Click to expand...

Subject to the caveats that users can always disable macros in any
particular workbook, internal password protection is easily overcome,
and macros in OTHER workbooks can operate on workbooks opened with
their own macros disabled. IOW, no robust way to prevent moderately
sophisticated users from obtaining access to EVERYTHING in any
workbook they can open.
 
Back
Top