Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Sheets | Excel Discussion (Misc queries) | |||
Restrict / Stop Printing | Excel Discussion (Misc queries) | |||
Macro to restrict printing to black and white | Excel Discussion (Misc queries) | |||
How to restrict printing to only completed tables in spreadsheet?. | Excel Discussion (Misc queries) | |||
Restrict access to certain sheets | Excel Discussion (Misc queries) |