How to restrict printing certain sheets
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 |
How to restrict printing certain sheets
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 |
How to restrict printing certain sheets
Kassie wrote...
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. 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. |
All times are GMT +1. The time now is 02:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com